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 ,

    Thanks for the update, please look into the below pbix file.

    If this helped, please mark it as the solution so others can benefit too. And if you found it useful, kudos are always appreciated.

    Thanks,
    Chaithra E.