Forum Discussion
Negative Goal Growth
Hi,
I have a report that I am working on where I am struggling with the logic a bit.
| Store # | $ Variance (Actual-LY). | Growth Goal. | % To Goal - Expected Column |
| 1 | ($500) | ($500) | 100% |
| 2 | ($1000) | ($2000) | 200% |
| 3 | $200 | ($400) | ??? |
| 4 | $100 | ($1000) | ??? |
| 5 | ($300) | ($100) | ??? |
I have stores that all have negative growth goals. Some stores have had a positive variance and some stores have had a negative variance. I am trying to write a DAX which will accurately show the % to goal. Admittedly, I am struggling a bit with the logic for the % to goal which is making writing a DAX difficult. I am wondering if anyone else has run into this issue or is able to help toubleshoot this for me.
Any suggestions would be greatly appreciated!!
2 Replies
FreemanZSuper User
hi Coffee1234 ,
this is indeed an issue. there are some recommendations like:
https://www.excelcampus.com/functions/percentage-change-formula-negative-numbers/https://www.wsj.com/public/resources/documents/doe-help.htm#netincome
here i quote:
A positive percent change is represented in green, while a negative percent change is displayed in red. Percent change is not provided if either the latest period or the year-ago period contains a net loss.
Hi, Coffee1234
May I ask if you have solved your problem? According to your description you are confused with the logic of calculating the % To Goal column when you have a negative value in the Variance column, in fact the divisor of the growth rate has to be a number greater than or equal to 0, otherwise this % To Goal is meaningless. You might consider displaying it as a numeric value only instead of a percentage.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
