Forum Discussion
Using selected value of what if parameter in a Calculated column
I am trying to get a number input from the end user using the What if Paramater. I would then like to use that number in a calculated column and show the calculated column as a category on a colum...
Thanks v-piga-msft for responding. 'Paramater Value' is a measure (or else what is it?) And I was using the Measure in a Calculated column - now I understand the calculated column would not get recalculate on change in measure/paramter value but was hoping at least clicking on refresh data would help? Is there anyway the calculated column can be forced to recalculate (by the end user)?
I am having the same issue. I can not create measure and it has to be a calculated column. Is there a way of having the value I decide in one of the columns so that I can use it in the calculated column?
Or createing measure is only the way?
Thanks
Nagaraj