Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Milan6687
Helper II
Helper II

Join table with multiple tables using left outer join

Hi,

 

I have one Master_table and one Worker_table with ten alias names having left outer join.

I don't want to do 10 merge as it will impact the performance.

 

Is there any way to achive the below sql in power bi using DAX.

 

Select E1.Name,E2.Name,...........E11.Name

FROM
Master_table E1,
Worker_table E2,
Worker_table E3,
Worker_table E4,
Worker_table E5,
Worker_table E6,
Worker_table E7,
Worker_table E8,
Worker_table E9,
Worker_table E10,
Worker_table E11
WHERE
(E2."RC_UID" = E1."L1_RC")
AND (E3."RC_UID"(+) = E1."L2_RC")
AND (E4."RC_UID"(+) = E1."L3_RC")
AND (E5."RC_UID"(+) = E1."L4_RC")
AND (E6."RC_UID"(+) = E1."L5_RC")
AND (E7."RC_UID"(+) = E1."L6_RC")
AND (E8."RC_UID"(+) = E1."L7_RC")
AND (E9."RC_UID"(+) = E1."L8_RC")
AND (E10."RC_UID"(+) = E1."L9_RC")
AND (E11."RC_UID"(+) = E1."L10_RC")
AND (E5."RC_TYPE" = 'ORGUNT')

 

Thanku,

Milan

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.