left outer join

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 …

Continue Reading about How to understand the difference between left outer and inner joins in Excel Power Query →