topic Re: Negative Goal Growth in DAX Commands and Tips

Negative Goal Growth

Coffee1234 — Thu, 11 Jan 2024 21:30:31 GMT

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!!

Re: Negative Goal Growth

FreemanZ — Fri, 12 Jan 2024 06:02:35 GMT

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.

Re: Negative Goal Growth

Anonymous — Thu, 25 Jan 2024 09:48:25 GMT

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 Team

If 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