Date Table Hierarchy Issue

[rocketship]

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!

[rocketship · Accepted solution]

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.

[rocketship]

Thanks for the quick responce. Unfortunatly Auto Date/Time was already selected for Time Intelligance in settings. Any other ideas?

Thanks, 

[Fowmy]

@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