Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

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.

1 ACCEPTED SOLUTION
avatar user
Anonymous
Not applicable

Syndicated - Outbound

 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.

View solution in original post

3 REPLIES 3
avatar user
Anonymous
Not applicable

Syndicated - Outbound

 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.

Fowmy
Super User
Super User

Syndicated - Outbound

@Anonymous 


Can you try replacing the calendarauto function with the CALENDAR function?

Example:
CALENDAR ("01/01/2019" , "31/12/2021" )

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

avatar user
Anonymous
Not applicable

Syndicated - Outbound

I still get the same results( values from the year 2019) when filtered by 2021.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)