The URL in the video is https://ift.tt/2NRz7gu
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.