Forum Discussion
Anonymous
7 years agoNot applicable
Letting user set date variable for calculated measures
Hi, Please can you tell me how to allow a user to set a date variable (on a report page) which will then be used by a calculated measure? I tried clicking on "New Parameter" expecting to see ...
- 7 years ago
Use the SELECTEDVALUE function:
https://www.sqlbi.com/articles/using-the-selectedvalue-function-in-dax/
https://community.powerbi.com/t5/Desktop/Use-selectedvalue-in-a-measure/td-p/483456
Anonymous
7 years agoNot applicable
I found a workaround. Just set the parameter up as a whole number, then find the parameter's field in the list of data tables and change the data type to date. That seems to change the parameter slicer to accept dates.