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...
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.
Anonymous
Can you try replacing the calendarauto function with the CALENDAR function?
Example:
CALENDAR ("01/01/2019" , "31/12/2021" )
I still get the same results( values from the year 2019) when filtered by 2021.