topic Re: Previous line in DAX Commands and Tips

Previous line

SLima — Tue, 09 Nov 2021 18:15:12 GMT

Get previous value.

Re: Previous line

smpa01 — Tue, 09 Nov 2021 18:33:38 GMT

SLima you would need a row identifier in the dataset

Column = VAR _0 = CALCULATE ( MAX ( 'Table'[RowIdentifier] ) ) VAR _1 = CALCULATE ( MAX ( 'Table'[Column2] ), FILTER ( ALL ( 'Table' ), 'Table'[RowIdentifier] = _0 - 1 ) ) RETURN _1

Re: Previous line

VahidDM — Tue, 09 Nov 2021 23:23:13 GMT

Hi SLima

Try this code to add a new column:

Calculada = VAR _A = CALCULATE ( MAX ( 'Table'[Coluna 1] ), FILTER ( ALL ( 'Table' ), 'Table'[Coluna 1] < EARLIER ( 'Table'[Coluna 1] ) ) ) RETURN CALCULATE ( MAX ( 'Table'[Coluna 2] ), FILTER ( ALL ( 'Table' ), 'Table'[Coluna 1] = _A ) )

output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!