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 ...
Hi JoyCornerstone, thanks - is that a normal slicer or a parameter slicer? How did you set the data type to "date"?
JoyCornerstone
Resolver II
Resolver IIA 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
Fantastic, thank you :smileyhappy: