Forum Discussion

nish18_1990's avatar
nish18_1990
Helper III
1 year ago
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...
  • johnt75's avatar
    johnt75
    1 year ago

    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.

v-echaithra's avatar
v-echaithra
Community Support
1 year ago

Hi nish18_1990 ,

May I ask if you have gotten this issue resolved?

 

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

 

Regards,
Chaithra.