Forum Discussion

hueuro's avatar
hueuro
Frequent Visitor
2 years ago

DAX FORMULA

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%

 

 

2 Replies

  • StrategicSavvy's avatar
    StrategicSavvy
    Icon for Resolver II rankResolver II
    2 years ago

    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 ! 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    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.