How to add previous value of a column with a fixed valueand keep getting the summation

[Anonymous]

Hello,

I'm trying to calculate a  variable in power BI (let's call it Loss) that for the first row will return an initial value that i set, and starting from the second row, will return Previous(Loss) + Step. 

Here is an example of what i'm trying to get: 

(initial value= 200 ; Step=15)

Loss
200
215
230
245
260
275
290

Thank you in advance for your help. 

Fiorella 

[v-shex-msft · Accepted solution]

Hi @Anonymous ,

You can add a calculate column to get diff between current value and first value:

Step = [Loss]-MIN(T1[Loss])

Regards,

Xiaoxin Sheng