Request for support in marking the highest value X with equality Y

[MSPAL]

Hello community,

I need a formula for a calulated column that shows me the highest value in column X if the values in column Y are the same.

Example: Several orders are posted on one date for a costumer, but I only want to look at the latest (highest transaction number) entry.

Thanks for your help,

Marco

[sjoerdvn · Accepted solution]

Try something like this (adjust for your actual table & columns names)

Last transaction = CALCULATE(MAX([Transaction no]),ALLEXCEPT('Transactions', 'Transactions'[Customer ID], 'Transactions'[Transaction date]))

[MSPAL]

ADD: I need a formula for a calulated column that shows me the highest value in column X if the values in column Y AND Z are the same.

Example: Several orders are posted on one date for a costumer, but I only want to look at the latest (highest transaction number) entry. Transaction number = X, Date = Y, Costumer ID = Z.