Forum Discussion

Digger's avatar
Digger
Post Patron
5 years ago
Solved

Date hierarchy

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

  • Digger 

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

1 Reply

  • Digger 

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