What's the difference between using: [column] [this]. [column] [_this row] .column]

whatโ€™s the difference between using:

[column]
[this]. [column]
[_this row] .column]

0 1 372
1 REPLY 1

Steve
Platinum 4
Platinum 4

Use [Column] to refer to the value of the Column column. See Column Value Expressions

Use [_THIS] in column constraint expressions to refer to the current value of the column to which the column constraint applies. See Column Constraints.

Use [_THISROW].[Column] within FILTER(), LOOKUP(), MAXROW(), MINROW(), and SELECT() expressions to refer to the value of the Column column of the row from which the expression was evaluated, rather than the row being examined; use [Column] (without the leading [_THISROW].) to refer to the value of the Column column of the row being examined.

Top Labels in this Space