Left Outer Join Help

[outatime]

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:

[AilleryO]

Hi,

If you Merge both queries in Power Query using JoinKind.FullOuter, you should get the desired outcome.

Let us know

[outatime]

I cannot do it in Power Query because the Date table is derived through DAX.

[AilleryO · Accepted solution]

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

[amitchandak]

@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/