Рет қаралды 143
Running Totals from Max Monthly Values - Power Query Challenge 05 (Step-by-Step Tutorial)
In this video, we tackle a Power Query challenge where we calculate running totals based on the maximum value for each month. Follow along step-by-step to learn how to extract the month from dates, group data, calculate running totals, and merge results. This tutorial is perfect for anyone looking to enhance their Power Query skills in Excel.
If you find this video helpful, please give it a thumbs up and subscribe to my channel for more Power Query tips and challenges. Thank you for watching!
Links:
Vijay A.Verma:
1) LinkedIn Profile: / excelbi
2) Download the file: onedrive.live.com/view.aspx?r...
3) Original post: www.linkedin.com/posts/excelb...
4) Vijay A.Verma's Website: excelbianalytics.com
'Power Query Challenges' Playlist: • Power Query Challenges...
Timestamps:
00:00 - Introduction
00:09 - Loading Data
00:16 - Extracting Month from Dates
00:30 - Grouping Data by Month
00:48 - Adding an Index Column
00:58 - Calculating Running Total
01:28 - Merging with Original Table
01:52 - Expanding Merged Column
02:03 - Conclusion
#PowerQuery #ExcelTutorial #ExcelChallenge #HowToLearnExcel