topic Re: Forecast Days Parameter in DAX in DAX Commands and Tips

Forecast Days Parameter in DAX

ralph_schroeder — Sun, 05 Jun 2022 20:11:23 GMT

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!

Re: Forecast Days Parameter in DAX

DimaMD — Mon, 06 Jun 2022 08:22:29 GMT

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

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

Re: Forecast Days Parameter in DAX

Anonymous — Wed, 08 Jun 2022 09:46:27 GMT

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