Letting user set date variable for calculated measures

[CloudMonkey]

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 an option to enter a date but there doesn't appear to be such an option?:

Thanks,

CM

[JoyCornerstone]

I use a slicer for dates and allow them to pick a single date or a date range. That value then becomes the selected value for the measure.  

[CloudMonkey]

Hi @JoyCornerstone, thanks - is that a normal slicer or a parameter slicer? How did you set the data type to "date"?

[JoyCornerstone]

A normal slicer.  In your data model, you should have a Calendar table that contains a date range for the set of dates in your system.  If you don't have that, you'll need to go search for how to set that up and connect it to your underlying table.

[CloudMonkey]

Thanks @JoyCornerstone , sorry but how do you get the selected value into a parameter/measure? If I create a slicer doesn't that just filter the underlying tables?

[JoyCornerstone · Accepted solution]

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

[CloudMonkey]

Fantastic, thank you 

[CloudMonkey]

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.