Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have 2 tables. Table 1 one has columns A,B and C . I created an additional column D using DAX formula. I want to merge this table with table 2 having column A,B,D,E.
The problem is I am not able to see column D for table1 in query editor so I am not able to use merge queries.
Can someone help me in solving this issue?
Thanks,
Sarita
Solved! Go to Solution.
Ok so I used LOOKUPValue function and it solved the issue.
If you can please confirm are you merging the tables in the Power BI Data Model or in the Query Editor? (Because you refer to DAX, as well as the Query Editor)
Hi @GilbertQ,
I used DAX to create column D in Table1 and now i am looking for ways to merge table 1 with table 2. I usually use merge queries of query editor to merge tables but because i am not able to see column D in the query editor I am wondering how else can I achieve this merge? Can NaturalLeftOuterjoin function in DAX help me? if so How?
I Appreciate your help!
Regards,
Sarita
Ok so I used LOOKUPValue function and it solved the issue.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |