Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago
Solved

Maximum value associated with revision

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

  • Captura.PNG
  • tamdo95's avatar
    tamdo95
    5 years ago

    Hello,

    Here is my solution:

    amountLastRevision =
    VAR lastRevision =
    CALCULATE ( MAX ( 'Table'[Revision] ) )
    RETURN
    CALCULATE ( VALUES ( 'Table'[Importe] ), 'Table'[Revision] = lastRevision )

     

1 Reply

  • tamdo95's avatar
    tamdo95
    Frequent Visitor
    5 years ago

    Hello,

    Here is my solution:

    amountLastRevision =
    VAR lastRevision =
    CALCULATE ( MAX ( 'Table'[Revision] ) )
    RETURN
    CALCULATE ( VALUES ( 'Table'[Importe] ), 'Table'[Revision] = lastRevision )