Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 coming -ve.it should be positive
MOM = IFERROR( ([CM 2]-[PM])/ABS([PM]),"")
MOM2 = IFERROR( ([CM 2]-[PM])/([PM]),"")
Please help how can i get current variance%
@hueuro MOM_Variance =
VAR MoM = ([CM 2] - [PM]) / ABS([PM])
RETURN
IF(
[CM 2] >= [PM], -- Check if CM is higher than or equal to PM
MoM, -- If CM is higher, return MoM as is
-MoM -- If CM is lower, return the negative of MoM
)
hi
i make like this its working but still one error in yoy%
@hueuro Hi! Try:
MoM% =
VAR CurrentMonth = [CM 2]
VAR PreviousMonth = [PM]
VAR Variance = CurrentMonth - PreviousMonth
RETURN
IF(
Variance >= 0,
DIVIDE(Variance, PreviousMonth),
- DIVIDE(Variance, PreviousMonth)
)
BBF
hi
i make like this its working but still one error in yoy%
User | Count |
---|---|
50 | |
24 | |
18 | |
17 | |
14 |
User | Count |
---|---|
91 | |
86 | |
39 | |
25 | |
20 |