The Power Query Magic YouTube version is available here... https://youtu.be/OKKAwlUIUW4 Reza Rad is a flamenco guitar playing Power BI community "stalwart". Look up the definition of the word "stalwart" and you'll find something like this "a dedicated, reliable, and hard-working supporter of an organization or team" .  This is Reza, he contributes to the Power BI community in so many ways I question when he has time to sleep! Reza was one of the first to blog about the early versions of Power BI, we touch on SSIS and discuss what a "Microsoft Regional Director" role involves - it's not what you'd think.   Links:   Website: Home - RADACAD Most Popular Article https://radacad.com/append-vs-merge-in-power-bi-and-power-query Favourite Articles: https://radacad.com/grouping-in-power-query-getting-the-last-item-in-each-group