Forum Discussion

ragnezza's avatar
ragnezza
Frequent Visitor
3 years ago
Solved

Date Range based on Slicer selection

Hello - I'm looking to return a list of the previous "X" days based on a selected day from a slicer.   For example, once a day is selected in the 'Date' slicer, I want to return the date range in t...
dynamic data filtering
Dynamic data selection
Dynamic data selection based on date
Dynamic Visuals
SELECTEDVALUE
  • ragnezza's avatar
    ragnezza
    3 years ago

    Thanks DataNinja777 . This can work if I want to have the cumulative "Daily Trends" up to the selected day.
    For this purpose I find this other solution:

    Measure =
    if( MAX( 'Main_Table'[Date]) >= SELECTEDVALUE('Date'[Date],min('Date'[Date]) )-180 &&
    MAX( 'Main_Table'[Date]) <= SELECTEDVALUE('Date'[Date],max('Date'[Date]) ),
    "Yes", "No" )

     

    And then use this 'Measure' as a filter in the visualization.

ragnezza's avatar
ragnezza
Frequent Visitor
3 years ago

Thanks DataNinja777 . Your solutions provided a cumulative count for the last "X" days, while I was looking to include/exclude days based on the selection. I made it work with the following Measure and by adding a separate Table with just the 'Date' field, which is used as filter.

Measure_last_180_days = 

IF (SELECTEDVALUE('Date'[Date])-180 <= MAX( 'Main Table'[Date]) &&
SELECTEDVALUE('Date'[Date]) >= MAX('Main Table'[Date]),"yes","no" )