Previous Value from the same table

[ryanantonio]

I am currently making a validation rule where the value that is going to be added should be higher than the previous value that has been added previously. I am using the formula:
INDEX(Daily WTP Central[kWh Meter PLN],[_RowNumber]-2)

however it sometimes produce an error where the formula above returns 0 or a value that is not from previous row. Can you help me?

[jyothis_m · Accepted solution]

[_THIS]>ANY(SELECT(Daily WTP Central[kWh Meter PLN],[_RowNumber]=[_THISROW].[_RowNumber]-1))