Left Join without Merge in PowerBI

[damit23183]

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 table are joining. I can't delete any record because some data are designed like that to have multiple things (Rows) for same ID.

2) RELATIONSHIP: MANY to One applied but its only gives data which are common in both table. 

Expected Result: I would like to have all records from Left table and common from right table.

NOTE: There are more than 50 columns in LEFT TABLE and i want all becuase most of them are used to calculate either Measures or other new columns based on conditions.

I would like to achieve this result in LEFT table because do not want to create new table as I have already have more than 30 tables in data model.

The source of these data is Dynamic365, hope you can understand it is really difficult to find information (from Dynamic 265) so can't remove anything or perform Merge function as it gave me an error.

Any suggestion and help would be appreciated!

Thanks

[Greg_Deckler]

Maybe the DAX join functions like NATURALINNERJOIN and NATURALLEFTOUTERJOIN?

[damit23183]

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