Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

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 ...

Need Help

JoyCornerstone
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

Not applicable

7 years ago

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

Resolver II

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
Not applicable
7 years ago
Fantastic, thank you :smileyhappy:

Forum Discussion

Letting user set date variable for calculated measures

Related content

Dynamic Variable in Calculated Columns

DAX Calculated Measure

Understanding variable calculation

DAX Measure for Ranking the valid rows and calculating the average rating

Variable Table and measure calculation