Forum Discussion

Pramit4u's avatar
Pramit4u
New Member
8 years ago
Solved

Dynamic End Date on Slicer

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. 

Need Help

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    8 years ago

    Pramit4u,

     

    You may drag date from table below.

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