Forum Discussion

SaritaSenapati's avatar
SaritaSenapati
Helper I
9 years ago
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 ...
Need Help
  • SaritaSenapati's avatar
    SaritaSenapati
    9 years ago

    Ok so I used LOOKUPValue function and it solved the issue.

GilbertQ's avatar
GilbertQ
Super User
9 years ago

Hi SaritaSenapati

 

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)

SaritaSenapati's avatar
SaritaSenapati
Helper I
9 years ago

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

  • SaritaSenapati's avatar
    SaritaSenapati
    Helper I
    9 years ago

    Ok so I used LOOKUPValue function and it solved the issue.