Forum Discussion
Relative date based on slicer date
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.
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:
1 Reply
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: