Forum Discussion

damit23183's avatar
damit23183
Microsoft Employee
6 years ago

Left Join without Merge in PowerBI

Hi,   I am trying to achieve the result based on concept of SQL left join in PowerBI.    Steps I took:   1) MERGE: Didn't work as it gave me duplicate error becuase of IDs based on which two ta...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago
Maybe the DAX join functions like NATURALINNERJOIN and NATURALLEFTOUTERJOIN?
  • damit23183's avatar
    damit23183
    Microsoft Employee
    6 years ago

    Hi,

     

    Thanks for quick response.

     

    Yes i did think of it but the result of this function is new table which i dont want to create.

     

    I want to do everything in Primary table (left Table).

     

    Thanks