cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nssidhu Frequent Visitor
Frequent Visitor

Calculate measure Plus What if Scenario

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 ?

 

Sample.png

3 REPLIES 3
Phil_Seamark Super Contributor
Super Contributor

Re: Calculate measure Plus What if Scenario

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?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

nssidhu Frequent Visitor
Frequent Visitor

Re: Calculate measure Plus What if Scenario

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

v-huizhn-msft Super Contributor
Super Contributor

Re: Calculate measure Plus What if Scenario

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