topic Dynamic End Date on Slicer in Developer

Dynamic End Date on Slicer

Pramit4u — Fri, 10 Aug 2018 14:50:50 GMT

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.

Re: Dynamic End Date on Slicer

v-chuncz-msft — Mon, 13 Aug 2018 08:54:00 GMT

@Pramit4u,

You may drag date from table below.

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