Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculating $ and % Variance in DAX

I'm struggling to get something really simple correct here.    Current Matrix: Financials Actuals Forecast VAR $ VAR % Revenue $9,375,398  $10,119,803 ($744,405) -7.4% EBITDA ($5...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    Anonymous 
    You are 100% correct. Please try

    VAR % =
DIVIDE ( [VAR $], ABS ( [Forecast] ) )
tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Anonymous 
Please use 

VAR % =
- ABS ( DIVIDE ( [VAR $], [Forecast] ) )
Anonymous's avatar
Anonymous
Not applicable
4 years ago

This doesn't work; it renders positive amounts negative when the $ variance is positive, which is incorrect. 

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Anonymous 
    You are 100% correct. Please try

    VAR % =
DIVIDE ( [VAR $], ABS ( [Forecast] ) )