Forum Discussion

rocketship's avatar
rocketship
Frequent Visitor
5 years ago
Solved

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 Hierarch...
  • rocketship's avatar
    rocketship
    5 years ago

    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.

Fowmy's avatar
Fowmy
Super User
5 years ago

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 then 

Dates = 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 columns