In a previous post, we looked at some of the limitations of XLOOKUP() and other Excel "duct tape" lookup functions. Relational joins in Power Query were introduced as a more robust alternative. This …
How to understand relational joins in Excel Power Query
In my book Advancing into Analytics I called VLOOKUP() the "duct tape of Excel:" Technology tactics move quickly. Excel now offers XLOOKUP() as a modern alternative to VLOOKUP(). But the theories …
Continue Reading about How to understand relational joins in Excel Power Query →
How to do a Cartesian/cross join in Excel Power Query
If, as I write in Advancing into Analytics, lookup functions like VLOOKUP() are the duct tape of Excel, then relational joins in Power Query are like a full-on blowtorch, allowing you to contort data …
Continue Reading about How to do a Cartesian/cross join in Excel Power Query →