Thanks @Krunal,

I was unclear on this `RowId()`

issue.

This method is a pretty big ask for everyday Excel users coming over who just want to run calcs based on preceding values, which is a mundane task in Excel.

$.02

Also, while playing with this I arrived at another question.

The `Filter()`

formula documentation contains this:

If list is a table, use “`thisRow`

” to reference the current row being evaluated. Otherwise, use “`currentValue`

” to reference the current item being evaluated.

EXAMPLE STATEMENTS

`If(thisRow = thisTable.First(), start - start, start - thisTable.Filter(`

**thisRow**`.period =`

**thisRow**`.period - 1).end.First())`

`If(thisRow = thisTable.First(), start - start, start - thisTable.Filter(`

**CurrentValue**`.period =`

**thisRow**`.period - 1).end.First())`

When list is a table and `thisRow`

is used to reference the current row being evaluated, it makes it difficult to `Filter()`

using a logic statement that compares the `thisRow`

that’s being evaluated by `Filter()`

and the `thisRow`

that holds the formula in which `Filter()`

is being run (unless the two instances of `thisRow`

are unique under the hood?). Whereas, if the former were `CurrentValue`

(as with other lists) then `thisRow`

would still be free to use in the latter, and the two could be compared…??

What’s the correct way to think about this? (Because I’m confused !!)