Negative expense variances

[ammartino44]

Hello. I'm reading a financial tutorial for powerpivot dax. They have revenues that are negatives and expenses that are positive. They handle this issue with the formula below. I don't have this issue, my values are mostly positive. However, there are a few expense items that can sometimes be either negative or positive. How can I calculate a proper year over year % change? 

For example, in my picture. The calculation is Yoy= current year-prior year. This calculation works correctly and makes sense. The year over year percentage change= YoY change/prior year. This calculation does not always make sense because the prior year/current year could be negative/negative, positive/negative, negative/positive. How can I write a formula to address this issue? 

IF(

    CONTAINS(Accounts, Accounts[Class], "Net Revenue"), -([Actual $]-[Prior $]),

([Actual $]-[Prior $])

[v-haibl-msft]

@ammartino44

In your screenshot, which result is incorrect, -300% and -700%? -15/5 = -300% seems to be right. What is your expected result here?

If you want all the expense to be positive, you can use ABS function mentioned by smoupre to transfer negative numbers to positive.

Best Regards,

Herbert

[Greg_Deckler]

Use the ABS function? https://msdn.microsoft.com/en-us/library/ee634566.aspx