DAX FORMULA

[hueuro]

HOW CAN I MAKE DAX FORMULA FOR MOM% IF THE CM IS HIGHER VALUE SHOULD BE POSITIVE.but mom i put abs with PM but still some exp getting positive (eg selling exp) when i remove abs mom2 see the total comming -ve.it should be positive

MOM = IFERROR( ([CM 2]-[PM])/ABS([PM]),"")

MOM2 = IFERROR( ([CM 2]-[PM])/([PM]),"")

Please help how can i get currect varience%

[lbendlin]

That is a surprisingly complex and very subjective topic.

What is the variance from -10 to +20 %  what about from -10 to 0?  What about from 0 to 20 ?

You need to go through all scenarios and decide for yourself which interpretation makes sense for you.  Using ABS is one common approach, but it does not cover all scenarios.

[StrategicSavvy]

Hi @hueuro 

@try using Dax SIGN function for handling positive negative values. Also instead of IFERROR use you can switch to DIVIDE function cause it's designed to handle 0-division / NaN / infinity errors. 

hope it helps !