topic Relative date based on slicer date in DAX Commands and Tips

Relative date based on slicer date

abeirne — Fri, 23 Dec 2022 22:40:46 GMT

Hi all, I am trying to show a 3 week snapshot based on the selected date that the user chooses.

So for 1/1/2022, in the table i would like to only see 1/1/2022 to 1/21/2022 and the bookings associated with those dates. Both of the dates being used in the slicer and table are the same date column in the Calendar table. I tried ranking the dates but that appears to be ranking per row in the table. Thank you for the help.

Re: Relative date based on slicer date

FreemanZ — Sat, 24 Dec 2022 02:52:05 GMT

hi abeirne

you would

1) need an isolated table for the Date slicer

2) plot the table visual with a measure refering the slicer-selected value like this:

@Booking = VAR _date = SELECTEDVALUE(datetbl[Date]) RETURN CALCULATE( MAX(data[Booking]), KEEPFILTERS(data[Date]>=_date &&data[Date]<=_date+13) )

i worked like this: