Power Query M: Pivot table with row, column and grand totals
This video is a walkthrough of my solution to the Excel BI challenge PQ44 from LinkedIn.
I take a cross-tabulated table of detailed data with month on columns and duplicate item labels on rows and collapse it to a unique by-year pivot table with row totals, column totals and a grand total.
Here's the link to the challenge:
/ excelbi_powerquerychallenge-daxchallenge-m...
Please consider following the Excel BI account on LinkedIn to participate in other challenges like this. It's a great way to practice your Power Query skills.