Forum Discussion

RENJITH_R_S's avatar
RENJITH_R_S
Icon for Resolver II rankResolver II
3 years ago
Solved

difference from previous row in a measure

Hi friends,

 

Can you help me to write a measure to acheive the Result

 

Sample Data

 

Period     Value      Result

p1            100         100

p2             150          50

p3             175           25

p4             225           50

p5             300           75

  • Hi RENJITH_R_S 
    You can achieve your goal, using the offset function.

    1. Create a basic sum measure:

    SumValue = sum('Table'[Value])
    2. Use it on your offset calculation measure:
    ValuesDiff = [SumValue]-
    CALCULATE([SumValue],OFFSET(-1,ALLSELECTED('Table'[Period]),ORDERBY('Table'[Period],ASC)))

    Link to a Sample file 

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

  • if you use a slicer or you have spaces in the date, it's better to write the measure like this

    CALCULATE(
          [SumValue],
           OFFSET(-1,
                SUMMARIZE(ALLSELECTED('Table'),'Table'[Period]),ORDERBY('Table'[Period],ASC)))

4 Replies

  • Hi RENJITH_R_S 
    You can achieve your goal, using the offset function.

    1. Create a basic sum measure:

    SumValue = sum('Table'[Value])
    2. Use it on your offset calculation measure:
    ValuesDiff = [SumValue]-
    CALCULATE([SumValue],OFFSET(-1,ALLSELECTED('Table'[Period]),ORDERBY('Table'[Period],ASC)))

    Link to a Sample file 

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

  • if you use a slicer or you have spaces in the date, it's better to write the measure like this

    CALCULATE(
          [SumValue],
           OFFSET(-1,
                SUMMARIZE(ALLSELECTED('Table'),'Table'[Period]),ORDERBY('Table'[Period],ASC)))