Need date range filter to automatically update with yesterday's date on a daily basis

[Rosh89]

Hi,

I have a sales report published in service which shows sales for the year 2022. I have a date slicer which is as shown below 

The date on the left (1/1/2022) should not change and the date on the right (1/3/2022) should update everyday with yesterday's date when a report is being sent today. Is there a way I can accomplish this using DAX in desktop and need not worry about changing the date manually in service everyday?

Thanks in advance.

Regards,

Rosh

[v-rzhou-msft]

Hi @Rosh89 ,

I think you can create a DimDate table by "Calendar" function in Dax.

Date = 
CALENDAR(DATE(2022,01,01),TODAY()-1)

It will always show dates in range from 2022/01/01 to yesterday.

 

Best Regards,
Rico Zhou

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

[Rosh89]

Hi @v-rzhou-msft,

I tried what you suggested but it does not work for sending emails automatically on a daily basis. The date slicer will always show the date the report was published from desktop to service. 

Best Regards,

Rosh 

[amitchandak]

@Rosh89 , As far as I know, you can not initialize date range slicer. You can log an idea https://ideas.powerbi.com/ideas/