Forum Discussion
Solved
Using a Date Parameter in DAX
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
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.
1 Reply
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.