Forum Discussion
Previous Value
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 |
No Replies