select automatically day day month -1 ,-2 , -3...

[randomUser21]

hello everybody,

I want the user to select a date, and that automatically the same date month -1,-2,-3,-4 etc is selected

like this : (format dd/MM/YYYY)

is it possible to do this?
someone can help me please

[Anonymous · Accepted solution]

Hi @randomUser21 ,

You can follow the steps below to get it:

1. Create a measure as below

Flag =
VAR _seldate =
    SELECTEDVALUE ( 'Date'[Date] )
VAR _curdate =
    SELECTEDVALUE ( 'Table'[Date] )
RETURN
    IF ( _curdate >= _seldate - 6 && _curdate <= _seldate, 1, 0 )

2. Apply a visual-level filter with the condition (Flag is 1) to filter the data on the visual

Best Regards