Date hierarchy showing dates beyond the actual max date of the date table

[Anonymous]

Hi guys,

i have a date table that i create with a min / max function from a date column of my sales table. Max date of that colum is 25.04.2020 as seen in the left date table. 

But once i create a hierarchy out of this colum the maximum date (as seen in the right table) goes up to 2020 Q4 which is beyond the 25.04.2020.

Any ideas?

Appreciate!

[v-yuta-msft · Accepted solution]

@Anonymous ,

Modify the format of Date column as mm/dd/yyyy and check if this issue persists.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mwegener]

Hi @Anonymous ,

do you use the Auto date/time Date Hierarchy?

This always represents a whole year.

https://docs.microsoft.com/de-de/power-bi/transform-model/desktop-auto-date-time