Forum Discussion
Date table not working
I built an SSAS Tabular model cube and created a date table using calendarauto. I have marked it as a date table and created a relationship with the fact table using the date column, and both columns have a Datetime data type.
When I analyze the data using excel, the date filter is not working correctly. For example, when I filter on the year 2021, it gives me row values for the year 2019 also, but if I use the date column from the fact table, I get the correct results.
When I analyze the Tabular cube using Power BI, it works right.
Could you please suggest what exactly is going wrong with our date table?
Thanks in advance.
- Anonymous5 years ago
When Analyzing the data on Excel using only attributes generates cross join, so now I understand that I should add a measure to my table.
3 Replies
- FowmySuper User
Anonymous
Can you try replacing the calendarauto function with the CALENDAR function?
Example:
CALENDAR ("01/01/2019" , "31/12/2021" )- AnonymousNot applicable
I still get the same results( values from the year 2019) when filtered by 2021.
- AnonymousNot applicable
When Analyzing the data on Excel using only attributes generates cross join, so now I understand that I should add a measure to my table.