Don’t Skip These: The 4 Easiest Power Query Transformations You Must Try

Learn how to create some nifty yet practical Power Query transformations using functions readily available to you in Power Query, such as Drill Down, Group By, Statistics, Custom Columns, Conditional Columns, and Merge.
💡 Please click here if you would like to subscribe to "The Query Editor" newsletter where you will receive Power Query tips, tricks and exclusive discounts to my upcoming courses: thequeryeditor.beehiiv.com/su...
📁 Please click here to download the practice file: drive.google.com/file/d/1ExVT...
✅ 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
00:00 Transformation 1
02:27 Transformation 2
05:51 Transformation 3
11:49 Transformation 4

[@heishoi]

thank you for your effort in making this video . l will need more time to understand and follow the last example

[@MissMicrosoft]

You’re most welcome, glad you’re enjoying the videos 😊

[@jeromeastier462]

Excellent, each step is straightforward yet the end-result is impressive. Thanx!

[@MissMicrosoft]

Thank you Jerome, glad you liked it!

[@heishoi]

Thanks

[@MissMicrosoft]

Thank you for all your support! I really appreciate it 😊😊

[@FRANKWHITE1996]

great video! thanks for sharing

[@MissMicrosoft]

Thanks for watching!

[@soniccheese01]

Thanks, very insightful. If the comparison in the last example was continually rolling forward. How would you compare January against December etc.? As the calculation is subtracting 1 to go back to previous month and this would break past 12. Possibly some sort of incrementing index number column. I'd be interested to know. But please keep your amazing videos coming. Love it.

[@MissMicrosoft]

You're welcome, glad you're enjoying the videos! Yes it would include an index column, but you would create the query a bit differently to what I've shown in the video. In the video the two index columns are used to merge the two tables. In the solution for comparing January to December, you're correct, index would be used as the incrementing index number to subtract the current row from the previous row. This would be done in a Custom Column. I will provide the solution in upcoming newsletters, please be sure to subscribe so you can get the practice file and solution once it's released: thequeryeditor.beehiiv.com/subscribe

[@akashdeshmukh116]

how to add that refresh button in excel??🤔

[@MissMicrosoft]

Please check out this video here: th-cam.com/video/aa0EDero41c/w-d-xo.htmlsi=_6R8a5O_s3bi4hoy hope it helps :)

[@akashdeshmukh116]

@@MissMicrosoft thank you 👍

[@MissMicrosoft]

You’re welcome!

[@thababozulu]

Speak slowly please