NATURALLEFTOUTERJOIN – new table using left outer join (DAX – Power Pivot, Power BI)

The NATURALLEFTOUTERJOIN function creates a new table from two other tables – using the Left Outer Join.

How to do it?

Let´s have two connected tables:

New table can be created using the NATURALLEFTOUTERJOIN. It will have all rows from the left table (the fact table) and connected rows from the dimension.

  • Table = NATURALLEFTOUTERJOIN(People;’Heads of departments’)