Forum Discussion
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...
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
Hi,
If you Merge both queries in Power Query using JoinKind.FullOuter, you should get the desired outcome.
Let us know
I cannot do it in Power Query because the Date table is derived through DAX.
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