Forum Discussion
Solved
Dynamic parameter selection for due days
Hi , I need a parameter on days selection . If i select Closure in the next 10 calendar days . It should show me the category where the closure date is in next 10 calendar days . "X" mentioned belo...
Create a numeric parameter ranging from 1 to the maximum number of days you want to be able to filter for. Then create a measure like
Closure date within X days = VAR ChosenDays = [Num Days Value] VAR RefDate = SELECTEDVALUE ( 'Table'[Closure Date] ) VAR DaysDiff = DATEDIFF ( TODAY (), RefDate, DAY ) VAR Result = IF ( DaysDiff <= ChosenDays, 1 ) RETURN ResultAdd that measure as a filter to your table or matrix visual, set to show only when the value is 1.
Create a numeric parameter ranging from 1 to the maximum number of days you want to be able to filter for. Then create a measure like
Closure date within X days =
VAR ChosenDays = [Num Days Value]
VAR RefDate =
SELECTEDVALUE ( 'Table'[Closure Date] )
VAR DaysDiff =
DATEDIFF ( TODAY (), RefDate, DAY )
VAR Result =
IF ( DaysDiff <= ChosenDays, 1 )
RETURN
Result
Add that measure as a filter to your table or matrix visual, set to show only when the value is 1.
This calculation worked but i need to change it a bit as it will give past dates than today as well. I included >today in and condition for Var Result.