Don't Skip This: The Crucial First Step of the Pros

Learn the crucial first step that Power Query Advanced users and Power BI Pro users take in these four examples using Power Query, Power Pivot and Power BI.
Please download the practice file here: drive.google.com/drive/folder...
Timestamps:
00:00 What's the Crucial First Step of the Pros?
00:24 Example 1 - Power Query
06:17 Example 2 - Power Pivot
08:33 Example 3 - Power Query
12:53 Example 4 - Power BI
✅ Please see link to video mentioned in this video:
🎦How the Pros Actually Learn DAX: Power BI DAX Essential Tutorial for Beginners: • Measures Versus Calcul...
✅ If you would like to connect on LinkedIn:
🤝 www.linkedin.com/in/missmicrosoft
✅ If you would like to support the channel by buying me a coffee, (it's really quick and easy), please use this link:
☕www.buymeacoffee.com/missmicr...
✅ For more videos please subscribe:
🔔 / @missmicrosoft

[@norbertschmidt6532]

Thank you very much. SUPER. Thanks for sharing and greetings from Germany.

[@MissMicrosoft]

Thank you! Glad you enjoyed the video!

[@djl8710]

Thanks I'm having a hard time explaining this to my coworkers!

[@MissMicrosoft]

You’re welcome, hope the video helps!

[@kebincui]

Excellent as always. Thanks for sharing.

[@MissMicrosoft]

You’re welcome Kebin :)

[@danielgoncalveslima9350]

Very Nice! In power query is easy !
From Brasil...😊

[@MissMicrosoft]

Thank you Daniel from Brasil 😊

[@eslamfahmy87]

Wonderful tutorial. But why you make a custom date column (MMM& YY) in Exp 2 despite of it's already recorded under the column headers which called (MMM- YYY).
Also, at Exp 3 we can make a dynamic filter with start & end date at PQ instead the hardcoded of dates by custom column.

[@googlegoogle-gg3dp]

Is it possible that Powe query show processing percentage.....like wise in status bar excel shows processing percentage if we formula apply on big data

[@googlegoogle-gg3dp]

Is there any good alternate of merge query...? As its takes lots of processing time for 1 M data to process almost 1 hour. Pls guide

[@googlegoogle-gg3dp]

I have 1 m record on which I want to apply group by to get max value of each category and then same value should reflect against each category in separate custom column.....I tried it but it will take almost 2 hours and eventually system hanged....any suggestions pls