Forum Discussion
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 ...
JoyCornerstone
Resolver II
Resolver III 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.
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.
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