Forum Discussion
How to add two cells
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
4 Replies
Any hints or tips?
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
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?
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
