Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
20 | |
14 | |
11 | |
8 | |
6 |
User | Count |
---|---|
23 | |
23 | |
20 | |
15 | |
10 |