Previous Value

[nicktann89]

In Excel I have been using the following expression in Column C

=if(A3<1, B3*21, C2)

Essentially returning the calculated value in column C if the value in column A is lees than 1 and the value in the previous row of column C if it is greater than 1.

How can this be done in a calculated column in PowerBI? 

See sample data below.

A	B	C
0.2	5.3	111.3
0.3	5.2	109.2
0.5	5.8	121.8
0.2	5.7	119.7
1.5	8.4	119.7
1.6	8.4	119.7
0.2	5.3	111.3
0.3	5.4	113.4
0.2	5.3	111.3
0.2	5.2	109.2
1.5	8.4	109.2
1.6	8.4	109.2