Forum Discussion
Date Table Hierarchy Issue
I'm having some date table issues in a new report I'm buiding. I'm seeing this icon I"m not familiar with and I'm not able to create a proper date Hierarchy.
When I create the Hierarchy, it looks like this
On a separate report i'm working with, this is the date table which works correctly for me.
The Dax for both master date tables is exactly the same:
Master Date =
CALENDAR (
DATE ( 2020, 1, 1 ),
TODAY()
)
Wondering what's going on.
Thanks!
The issue is related to the fact table and the formatting of the date from SQL. Because of an on prem dataset, live connection, I'm not able to use power query to fix. Had to go to database admin to fix.
3 Replies
rocketship
When you create a data table, always ensure the full year dates in your calendar table. in your case, you can see it up as with the additional columns thenDates = CALENDAR( DATE( 2020, 1, 1) , DATE(2020, 12, 31) ) )
You need to enable the Auto Date Time under the Options as follows to get the date hierarchy for your date columnsThanks for the quick responce. Unfortunatly Auto Date/Time was already selected for Time Intelligance in settings. Any other ideas?
Thanks,
The issue is related to the fact table and the formatting of the date from SQL. Because of an on prem dataset, live connection, I'm not able to use power query to fix. Had to go to database admin to fix.
