Calendar Table

[Marian1981]

Hi All ! 

I've got three fact tables will their own date column and I've created a calendar table in order create a relationship between the tables based on that. When using now the date field from the calendar table to filter or to look at any data from any of the fact table, I get just blanks in the date column of the matrix. I tried to connect one table at a time, checked the relationships and the data type, filters, etc. All seems alright but still the model is acting like there is no relation betweem them. I tried different calendars- CalendarAuto, Calendar, and a calendar that works perfect on a different report.

I have exacly the same model based on different data on another report, and it works as expected. 

Has anybody experienced this ?

Thank you

[Marian1981 · Accepted solution]

Hi @manvishah17 !

I think I found what the problem was but the data is loading just now on the desktop and can't confirm.

I was changing the data type of the date columns on the desktop, but when I checked in the power query they were having different type. So I changed it in the power query to match on each table including the calendar and now I am waiting on the data to load. 

Also, I though MARK AS DATE TABLE, is not necessary for the relationship to work ? Unless I need some time intelligence calculations. I will let you know if what I did worked. 

Cheers !

[manvishah17]

Hi @Marian1981 ,
Please check datatype of all your date columns whether they are date or not? 
Second mark your datetable as MARK AS DATETABLE. 
If this not resolve your query please do share your sample file.