Forum Discussion
How to make calculated measure into a static column
This post has closed.
4 Replies
- wdx223_Daniel
Community Champion
to create a parameter table, say Par_KPI, with a column of Date, then input two days in it.
change your formula to reference to these date
Thanks for your response. But I need the date to be dynamic based on the user selection. How could I do that?
v-jingzhangCommunity Support
Hi Anonymous
It seems you are using a date slicer or filter in the report to change the date range. However, filters and slicers in the report are not able to change the data in calculated columns because calculated columns are initialized when they are created in the model before users' interactions.
Since your purpose is to change the date range in other computations required, you could create measures to perform the computations and add date range filters into measures. Measures are able to be changed dynamically by slicers and filters in the report.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.- Syndicate_Admin
Administrator
Hi @zalalu
It seems you are using a date slicer or filter in the report to change the date range. However, filters and slicers in the report are not able to change the data in calculated columns because calculated columns are initialized when they are created in the model before users' interactions.
Since your purpose is to change the date range in other computations required, you could create measures to perform the computations and add date range filters into measures. Measures are able to be changed dynamically by slicers and filters in the report.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
