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

      • ahuhn's avatar
        ahuhn
        Advocate I
        7 years ago

        Thanks for the suggestion.

         

        I renamed name to name1, made a relationship between the two tables, and ran

         

        Table = NATURALLEFTOUTERJOIN('Now','Before')

         

        succssfully