Using a Date Parameter in DAX

PaisleyPrince — Wed, 13 Nov 2024 21:44:13 GMT

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

Re: Using a Date Parameter in DAX

Sahir_Maharaj — Wed, 13 Nov 2024 23:14:42 GMT

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.

topic Re: Using a Date Parameter in DAX in DAX Commands and Tips

Using a Date Parameter in DAX

Re: Using a Date Parameter in DAX