Forum Discussion

SSS's avatar
SSS
Icon for Helper I rankHelper 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
Icon for Community Champion rankCommunity Champion
8 years ago

SSS

 

Try these measures

 

First Create this Measure

 

Difference =
VAR Followingday =
    NEXTDAY ( Consulta1[Date] )
RETURN
    [Medida]
        - CALCULATE (
            [Medida],
            FILTER ( ALL ( Consulta1 ), Consulta1[Date] = Followingday )
        )
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    8 years ago

    SSS

     

    Now create this one

     

    Cumulative=
IF (
    HASONEVALUE ( Consulta1[Date] ),
    SUMX (
        FILTER (
            ALL ( Consulta1[Date] ),
            Consulta1[Date] <= VALUES ( Consulta1[Date] )
        ),
        [Difference]
    )
)
    • SSS's avatar
      SSS
      Icon for Helper I rankHelper 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
        Icon for Community Champion rankCommunity Champion
        8 years ago

        SSS

         

        Do you want to reset both Difference and Cumulative?