Forum Discussion
Solved
merge issue
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 ...
Ok so I used LOOKUPValue function and it solved the issue.
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.