Forum Discussion

abeirne's avatar
abeirne
Helper II
3 years ago
Solved

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 bookin...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    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:

     

     

FreemanZ's avatar
FreemanZ
Super User
3 years ago

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: