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?

TomMartens's avatar
TomMartens
Super User
9 years ago

Hey,

 

currently I have no idea, but please have a look at the solution from Vvelarde it uses a similar approach, maybe you can adapt to his approach.

 

Regards