Forum Discussion
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 what I want to achieve:
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
4 Replies
outatime , On is join them on date use date from the first table rest of the column from other table and use this option - For date
Or try new tables with joins
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
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
