Forecast Days Parameter in DAX

[ralph_schroeder]

In Report Builder, I have a task activity table with due date.  I want to have a user select a report parameter "Forecast Days" (=7 days, 30 days, 90 days) that filters the task due date.  So for example, selecting "30 Days" the table will show task due dates between today and +30 days.  What is the DAX for this?  Thanks!

[Anonymous · Accepted solution]

Hi @ralph_schroeder ,

Create a table like below and use it as slicer.

Then create a measure like below and add it to visual filter set value = 1.

Measure =
IF (
    SELECTEDVALUE ( 'Table'[Date] ) <= TODAY ()
        && SELECTEDVALUE ( 'Table'[Date] )
            > TODAY () - SELECTEDVALUE ( slicer[slicer] ),
    1
)

Best Regards,

Jay

[DimaMD]

Hi, @ralph_schroeder 
You can create a Numeric parameter, and use the DATEADD function

CALCULATE(
         [measure],
            DATEADD('Dates'[Date],
                [Value "Parameter"],
                DAY)
            )