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

Подписаться 8 тыс.

Просмотров 3 тыс.

50% 1

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

Опубликовано:

29 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 15

@heishoi 3 месяца назад

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

@MissMicrosoft 3 месяца назад

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

@jeromeastier462 6 месяцев назад

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

@MissMicrosoft 6 месяцев назад

Thank you Jerome, glad you liked it!

@FRANKWHITE1996 6 месяцев назад

great video! thanks for sharing

@MissMicrosoft 6 месяцев назад

Thanks for watching!

@heishoi 3 месяца назад

Thanks

@MissMicrosoft 3 месяца назад

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

@soniccheese01 6 месяцев назад

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 6 месяцев назад

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