Forum Discussion
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 co...
StrategicSavvy
Resolver II
Resolver IIHi 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 !