Forum

Automatic Date Tabl...
 
Notifications
Clear all

Automatic Date Table

2 Posts
2 Users
0 Reactions
81 Views
(@nd09689)
Posts: 23
Trusted Member
Topic starter
 

HI, I tried to change the data set from 2018 to 2019 when creating automatic data columns with power pivot , data table function,

But it goes back to 2018. Please see attachment, how can I create or update to 2019? I duplicated the table and just changed the dates to 2019, and it did not work.

 
Posted : 18/06/2019 4:08 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Junko,

Once you have 2018 in your file I suspect it is stored in the Power Pivot Cache somewhere and you can't change that.

Mynda

 
Posted : 18/06/2019 5:21 pm
Share: