Aggregating Joins in Power Query: the mysteries

This video explores Aggregating Joins. These are strange because they can be handy. However, as we see in the video, sometimes Grouping or regular joins are better solutions. Still, you should know that Aggregating Joins is available to you.

I’m interesting in knowing your thoughts on this. Do you use Aggregate Joins a lot? Whats’t he deal?

Thumbnail image taken by Marina Green Photography


My book: Guerrilla Data Analysis 2nd Edition
My old blog: