Dynamic End Date on Slicer

[Pramit4u]

We have a use case where we want the End date in a Data Slicer to show the current date or previous date whenever the user opens the report. The Start date can be set to a default value(say 01/01 of that year). Any pointers on this would be really helpful. 

[v-chuncz-msft · Accepted solution]

@Pramit4u,

You may drag date from table below.

Table =
CALENDAR ( DATE ( YEAR ( TODAY () ), 1, 1 ), TODAY () )