I have a requirement to see what a change in product price would bring using what if scenario. I want recalculations done using new what if value .
Calculated column works fine, but it does not update calculation when a price in what if screnario is changed. Can i force to recalcuate on calculated columns on changes of what if price ?
Are there any other alternative ?
Values in calculated columns are computed when data is refreshed and then locked down - so updating a price in a whatif cannot change them. They will work with calculated measres, so perhaps look to create a calculated measure that uses the value from your calculated column and then applies an adjustment from your whatif measure.
Does that make sense?
Proud to be a Datanaut!