Calculate measure Plus What if Scenario

[nssidhu]

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 ?

[v-huizhn-msft]

Hi @nssidhu,

Based on your sample table, please list the expected result. So that we can try to help and post solution which is close to your requirement.

Thanks,
Angelia

[Phil_Seamark]

HI @nssidhu

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?

[nssidhu]

I understand that, but looking for solutiuon example specific to the problem