topic Re: Add current value to previous row value (with condition) in DAX Commands and Tips

Add current value to previous row value (with condition)

Anonymous — Tue, 17 Dec 2019 15:02:38 GMT

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

Re: Add current value to previous row value (with condition)

saraMissBI — Tue, 17 Dec 2019 18:38:35 GMT

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!

Re: Add current value to previous row value (with condition)

Anonymous — Wed, 18 Dec 2019 10:54:18 GMT

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"?