How to make calculated measure into a static column

[Anonymous]

This post has closed.

[Syndicate_Admin]

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.

[v-jingzhang]

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.

[wdx223_Daniel]

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 

[Anonymous]

@wdx223_Daniel ,

Thanks for your response. But I need the date to be dynamic based on the user selection. How could I do that?