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
Microsoft Phil_Seamark
Microsoft

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!

Highlighted
nssidhu Frequent Visitor
Frequent Visitor

Re: Calculate measure Plus What if Scenario

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

Microsoft v-huizhn-msft
Microsoft

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

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors