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]
    )
)
SSS's avatar
SSS
Helper I
8 years ago

Thanks Zubair_Muhammad, your solution works!!

Could I ask if it is possible to add one last issue? I would like the cumulative sum to reset each month, it is possible?

 

Thanks!

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

SSS

 

Do you want to reset both Difference and Cumulative?

  • SSS's avatar
    SSS
    Helper I
    8 years ago

    Hi Zubair_Muhammad,

     

    Just the Cumulative!!

    • 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!!!