Fact table is not working with Calendar table

[stino123]

HI,

I have the following relationship between my calendar table and my fact table which demonstrates number of visitors. Both the data types are date/time, I have played around with the types without success.

When I try to model the data (demonstrate visitors per month) it will not create the visual as such:

However if I delete the relationship I can model the data with the date in my fact table. I need it to work with my calendar so that I can create dax between my other related tables. 

Thanks in Advance,

[stino123 · Accepted solution]

Hey @amitchandak, I managed to find the solution. It seems that when I changed the type of data in my fact table in the table function on desktop it did not work. However in Power query by changing the date table in my fact table from date/time to date the relationship did work. Thanks for the help though

[amitchandak]

@stino123 , 1. You date table do not have dates which used in fact

2. Your date in fact has timestamp and it is not visible because you used datatype date in DAX.

3. Create a date column, Date = Datevalues([datetime]), and join that with the date table 

refer blog and video for details

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI:https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...