Using a Date Parameter in DAX

[PaisleyPrince]

Hi,

I would like to create a scenario where a user chooses a date which is then used to calculate the number of days,weeks and months between the user's chosen date and dates in a table column which are shown in a report.

The parameter should have a default value of today's date.

Would you be able to advise me of the easiest way to do this ?

Many thanks

Scott

[Sahir_Maharaj · Accepted solution]

Hello @PaisleyPrince,

Can you please try creating a date parameter and use it to dynamically calculate the difference:

Days Difference = 
VAR ChosenDate = SELECTEDVALUE('Selected Date'[Date], TODAY())
RETURN
    DATEDIFF(ChosenDate, MIN('YourTable'[DateColumn]), DAY)

Weeks Difference = 
VAR ChosenDate = SELECTEDVALUE('Selected Date'[Date], TODAY())
RETURN
    DATEDIFF(ChosenDate, MIN('YourTable'[DateColumn]), WEEK)

Months Difference = 
VAR ChosenDate = SELECTEDVALUE('Selected Date'[Date], TODAY())
RETURN
    DATEDIFF(ChosenDate, MIN('YourTable'[DateColumn]), MONTH)

Hope this helps.