Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Adding an IF condition to a Measure

Hello, I am trying to reply an Excel Rule into DAX Measure The idea is: When Result < 0, sum Result + Last Month C/C (superior line), otherwise, just reply the result So just reply the result wh...
Need Help
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
1 year ago

hi Anonymous ,

 

try like:

measure =

VAR _lm = EDATE(MAX('dim_Calendario'[Data]), -1)

VAR _lmcc =

SUMX(

        FILTER(

            ALL('dim_Calendario'),

            'dim_Calendario'[Data] <= _lm

        ),

        [Result]

    )

RETURN

IF([Result]<0, [Result] +_lm, [Result])

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hello FreemanZ 

 

Thank you but it didnt work