Forum Discussion

outatime's avatar
outatime
Regular Visitor
4 years ago
Solved

Left Outer Join Help

hello there, Need help on how to use the left outer join in DAX.  I can do it in SQL but in DAX, it gives an error saying no common join columns are detected. Basically, the illustration below is wh...
Need Help
  • AilleryO's avatar
    AilleryO
    4 years ago

    Hi,

     

    So equivalent in DAX is create a new table with :

    NewTable = NATURALLEFTOUTERJOIN( TabDates , TabTasks)

    It should give you expected outcome :

    and if you display this in a visual, look at amitchandak post to display all values, otherwise it will display only dates with values.

    Tell us if it works as expected