Forum Discussion

ammartino44's avatar
ammartino44
Icon for Helper III rankHelper III
9 years ago

Negative expense variances

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 issu...
Need Help
v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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