Maximum value associated with revision

[Syndicate_Admin]

Good morning Community!

I need to create a measure that shows me only the amount of the last revision, associated with each Customer Code.

Thanks a lot

• 

[Syndicate_Admin]

I need to create a measure that shows me only the amount of the last revision, associated with each Customer Code.

Thanks a lot

[tamdo95 · Accepted solution]

Hello,

Here is my solution:

amountLastRevision =

VAR lastRevision =

CALCULATE ( MAX ( 'Table'[Revision] ) )

RETURN

CALCULATE ( VALUES ( 'Table'[Importe] ), 'Table'[Revision] = lastRevision )