Forum Discussion

ahuhn's avatar
ahuhn
Advocate I
7 years ago

full outer join in dax

I am trying to do a full outer join in DAX (not in PQ)   I have two tables, T1 and T2, and am trying to make a merged table, M, as shown below.   I tried combinations of crossjoin and gener...
Need Help
ahuhn's avatar
ahuhn
Advocate I
7 years ago

Very odd error:

 

No common join columns detected. The join function 'NATURALLEFTOUTERJOIN' requires at-least one common join column.

petrovnikitamai's avatar
petrovnikitamai
Resolver V
7 years ago
new table = 
naturalleftouterjoin(
selectcolumns(T1;"name";[name];"statusBefore";[statusBefore]);
selectcolumns(T2;"name";[name];"statusToday";[statusToday]))

i'm not sure, but try this