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...
lbendlin
Super User
Super UserThat 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.