topic Re: MOM VAR% in DAX Commands and Tips

MOM VAR%

hueuro — Fri, 05 Apr 2024 04:39:07 GMT

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%

Re: MOM VAR%

BeaBF — Fri, 05 Apr 2024 09:15:00 GMT

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

Re: MOM VAR%

johnbasha33 — Fri, 05 Apr 2024 09:24:26 GMT

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
)

Re: MOM VAR%

hueuro — Fri, 12 Apr 2024 16:14:20 GMT

i make like this its working but still one error in yoy%

MOM% =

VAR CM = SUM(Query1[Amount1])

VAR PM = CALCULATE([Net Profit 2], PREVIOUSMONTH(Query1[Posting Date]))

RETURN

IF(

ISBLANK(CM) || ISBLANK(PM),

BLANK(),

IF(

AND(

NOT(ISBLANK(CM)),

NOT(ISBLANK(PM))

IF(

[CM] > [PM],

(CM - PM) / PM,

-(PM - CM) / PM

)

for yoy am getting some of the data

Re: MOM VAR%

hueuro — Fri, 12 Apr 2024 16:14:59 GMT

i make like this its working but still one error in yoy%

MOM% =

VAR CM = SUM(Query1[Amount1])

VAR PM = CALCULATE([Net Profit 2], PREVIOUSMONTH(Query1[Posting Date]))

RETURN

IF(

ISBLANK(CM) || ISBLANK(PM),

BLANK(),

IF(

AND(

NOT(ISBLANK(CM)),

NOT(ISBLANK(PM))

IF(

[CM] > [PM],

(CM - PM) / PM,

-(PM - CM) / PM

)

for yoy am getting some of the data