Add current value to previous row value (with condition)

[Anonymous]

Hello everyone,

Is there any way that I can do this in Power BI? I want to make column "calculations" using this formula.

Thank you in advance,

Milena

[saraMissBI · Accepted solution]

Hi @Anonymous ,

Here is a solution to your problem. I am not sure if it is the most efficient solution, but it gives you the result needed.

First, I added an index column from the query editor to the table to be able to catch the previous value of Type and Size. Then, I added a calculated column with the formula below:

Please find the .pbix file here

(N.B. I updated the file please make sure you refresh the page to get the correct file!)

Please if that solves your problem, accept as solution and give kudos 🙂 

Thank you!

[Anonymous]

Hi @saraMissBI ,

Thank you so much, this works!

I have one additional queston, what should I do if I want to subtract values from column "Number"?