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           ...
  • Ritaf1983's avatar
    3 years ago

    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's avatar
    3 years ago

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