MOM VAR%

[hueuro]

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%

[johnbasha33]

@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
)

[hueuro]

hi 

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 

[BeaBF]

@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

[hueuro]

hi 

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