Forum Discussion

SSS's avatar
SSS
Helper I
8 years ago
Solved

Difference between consecutive values in a Measure

Good Afternoon,   I need help with an issue regarding the difference between two consecutive values in a Measure.   I've made a measure that allows me to SUM the values of number of operations fo...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    SSS

     

    Try this

     

    Cumulative=
IF (
    HASONEVALUE ( Consulta1[Date] ),
    SUMX (
        FILTER (
            ALL ( Consulta1[Date] ),
            Consulta1[Date] <= VALUES ( Consulta1[Date] )
                && MONTH ( Consulta1[Date] ) = MONTH ( VALUES ( Consulta1[Date] ) )
        ),
        [Difference]
    )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

SSS

 

Try this

 

Cumulative=
IF (
    HASONEVALUE ( Consulta1[Date] ),
    SUMX (
        FILTER (
            ALL ( Consulta1[Date] ),
            Consulta1[Date] <= VALUES ( Consulta1[Date] )
                && MONTH ( Consulta1[Date] ) = MONTH ( VALUES ( Consulta1[Date] ) )
        ),
        [Difference]
    )
)
  • SSS's avatar
    SSS
    Helper I
    8 years ago

    Zubair_Muhammad

    Thanks, I've tried your solution and it totally works!!!