Add current value to previous row value (with condition)

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!