Useful Power Query with Lookup To Summary Of Me - 2293

The URL in the video is
While importing data into Power Query, you want to VLOOKUP to a summarized version of the data. In this video, the first step is a quick query to produce total revenue by region as a lookup query. Then, when you merge in Power Query, you will VLOOKUP to bring the Region total to each row, so you can calculate that row's percentage of region. This video debuts the Group By feature in Power Query.

Microsoft Excel,Excel,Bill Jelen,MrExcel,Power Query Group By,Doing a SUMIFS with Power Query,VLOOKUP to Self during Power Query,Adding Summary Statistics in Power Query,power query,power query tutorial,group by,Calculate Percentage of Total with Power Query,