Calendar Table

Question

Hi All !&nbsp;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.&nbsp;Has anybody experienced this ?&nbsp;Thank you

marian1981 · Accepted Answer

Hi&nbsp;manvishah17&nbsp;!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.&nbsp;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.&nbsp;&nbsp;Cheers !

Forum Discussion

Related content

Calendar Slicer with Different Business Calendars

calendar table

Custom calendar

Calendar Table

Tweaking Financial Calendar