Date hierarchy

[Digger]

Why if i create new table with formula

Calendar = CALENDAR(DATE(2010,1,1),now())

One PBIX file create good table with hierarchy

But another PBIX file create wrong table without hierarchy

create hierarchy

make more rubbish like dublicate date column and offseted hierarchy without year, month and days

How create always good table

[ryan_mayu · Accepted solution]

@Digger 

pls go to file-> optons and settings -> options, select auto date/time in the Data Load.