Relationship with date table not working

Anonymous This worked like a charm. The data type needs to be set as "Date" in the Query Editor, just changing in the loaded data model does not work. Thanks!

Hi Anonymous, you were right. The issue was that in the Edit Query section, the field was formatted as date + time + timezone instead of date+time.

Changing this field + apply + reload all data solved the trick.

Thanks!

Woooow !!!! I've been trying to solve this problem for days, I've looked at all the videos I found, on all the sites, I've done a thousand tests and nothing... And finally here is the solution. You are extremely supportive!!!! 

My data type is showing as date but whenever itry to right my dax, my start date doesnt come up

I attempted to change the data type in the query from the Transform Data window, but PowerBI still fails to correlate correctly with the calendar table. Do you have any other ideas on how to fix this? Is this something where the file or query is corrupted for some reason and the process has to be started over? Thanks.

This is not the issue as both are selected as dates in query editor.  My table only seems to correlate to one specific date and ignores all the others.

Hi Anonymous, I am facing same problem. I have created date table using DAX in Power BI desktop. As I don't have date table in my source database. I have checked other dates types like order date and invoice date they match in data type both in Power query and report window. Can you please advice me what else can be problem???

Thanks in advance!!

Yes!

Finally it worked, why.... oh why.... is it like this....

Thanks!! 🙂

God bless you, you saved my day 😄 😄

I almost wasted 2 hours figuring out why the date join is not working.. it was the datatype difference in Edit Query section..Thanks!

Add another appreciation for this tip!