Forum Discussion

capko's avatar
capko
Icon for Helper II rankHelper II
2 years ago

Left outer join with many to many relationship

I'm facing a problem with Power BI and a NATURALLEFTOUTERJOIN. I have two tables that I would like to join using a left outer join but I have a many to many relationship and the documentation says it...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

capko , You can merge table in power queries

Merge Tables (Power Query) : https://youtu.be/zNrmbagO0Oo

 

In Dax, you can create many to many join and use the required columns and measures in visual

 

You can create a Bridge table- https://www.seerinteractive.com/blog/join-many-many-power-bi/

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda