difference from previous row in a measure

[RENJITH_R_S]

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

[Ritaf1983 · Accepted solution]

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

[Ahmedx · Accepted solution]

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)))

[Ahmedx · Accepted solution]

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)))

[RENJITH_R_S]

@Ahmedx Thanks

[Ritaf1983 · Accepted solution]

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

[RENJITH_R_S · Accepted solution]

Thank You @Ritaf1983