Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

What If Parameter Help

  We are trying to use the What-If function for the first time here.  We want to give our CFO/CEO the ability to change the budgeted Margin % to see how the bottom line is impacted.   But, w...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi TomMartens,

 

First of all, thank you for helping me.

 

I tried this

Budget%Margin = IF(HASONEVALUE(CRM_Dim_Projects[Province]),
var valueFromWhatIfParameter = 
  SWITCH(VALUES(CRM_Dim_Projects[Province])
    ,"NB", NB[NB Value]
    ,"NS", 'CM%'[CM% Value]
    ,0
  )
return
CALCULATE(AVERAGE(CRM_Fact_SalesOpportunities[Budget%Margin])+valueFromWhatIfParameter )
)

But it doesn't work. Could you have a look at my codes and tell me what is wrong please?

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous,

>>Thus far we have only been able to impact the entire Budget % Margin column, rather than focusing in on one margin adjustment.

Could you please explain this requirement in details? And share your sample table to test if I have any idea?

Best Regards,
Angelia