Forum Discussion
Anonymous
5 years agoNot applicable
How to make calculated measure into a static column
This post has closed.
v-jingzhang
Community Support
5 years agoHi 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.