multiple join
1 Topic
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, MilanSolved835Views0likes1Comment