- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Anonymous
Can you try replacing the calendarauto function with the CALENDAR function?
Example:
CALENDAR ("01/01/2019" , "31/12/2021" )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-08-2024 10:34 PM | |||
01-04-2024 09:53 AM | |||
02-24-2021 01:44 AM | |||
09-28-2023 09:47 AM | |||
06-10-2024 08:51 PM |
User | Count |
---|---|
141 | |
111 | |
81 | |
61 | |
46 |