Automatic Update of Date table

[Anonymous]

Hi,

So my issue is I want to automate a business process completely. Let us say that I get data about the items my shop sells everynight, and let us assume that I manage to change the data source to update (append the new file). So I have up-to-date data, however my date table, that I use in most my visualisations is still the same, therefore I have to manually add data to it. 
This issue is my question, is it possible to automatically update my date table aswell?

Note: I tried adding a whole future year to my table (hoping that I would only need to update once a year) however this additional future year still shows in my visualisations (slicer), which is wrong as there is no data for it.
Therefore another possible fix could be to somehow make the visualisations (date slicer) shows only the dates that my fact table data has. 

[v-diye-msft · Accepted solution]

Hi @Anonymous 

I’ve created a sample as the fact table as below.

But we won’t manually add the date table generally. You can try to use the calendar table:

Table = CALENDAR(MIN(SalesSheet[Salestime]),MAX(SalesSheet[Salestime]))

Best regards,

Dina Ye

[Anonymous]

@v-diye-msft 
Thanks for your reply this method works just as you have mention, but it makes an ugly sclicer and since I have a much larger date range it looks too messy. My aim was to make it a hierarchy drop down menu for my date so it looks simpler and easier to navigate. 

[v-diye-msft]

Hi @Anonymous 

You could probably just change the slicer displaying by between, and select the day when needed.

[v-diye-msft]

Hi @Anonymous 

If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

Best regards,

Dina Ye