How to add two cells

[sputnik76]

This questions seems very simple but I can't figure it out. How do I add one specific cell to another in a series?  I want to add a cell to another cell from the previous row to sum up the numbers over the whole table.

In excel I would do it like this

= A1

= B1 + A1

= C1+ B1

etc 

[v-lili6-msft]

hi, @sputnik76 

It seems a rolling sum case, add a rank column and then use EARLIER Function create a formula like this:

CALCULATE(SUM([Value]),FILTER(ALL(table), (Rank=EARLIER(Rank)+1)||(Rank=EARLIER(Rank))))

If not your case, please share some data sample and expected output. Do mask sensitive data before uploading.

Best Regards,

Lin

[sputnik76]

Thanks I expect this is helpful but as a complete beginner I'm struggling with 'add a rank column'!  Can you elaborate or point me to a simple/clear resource?

[v-lili6-msft]

HI, @sputnik76 

Please share some sample data and expected output.

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

Lin

[sputnik76]

Any hints or tips?