Lookupvalue help

[Jaunkalns]

Hello,

I've been trying to find a solution to a problem when looking up a value from a different query.

How to adjust/change the LOOKUPVALUE formula so that it returns the sum of each Unique value from another query? (See example below)

Name:   Amount:

John       10

Peter      30

Sam       25

John       25

Name:   Amount:

John       35

Peter      30

Sam       25

Also, how to get the max amount?

Like this:

Name:   Amount:

John       25

Peter      30

Sam       25

Thanks!

[v-lili6-msft · Accepted solution]

Hi@Jaunkalns

You can add calculate columns to solve it simply by using Sum function and Max function

like :

SumAccount = CALCULATE(SUM(Table4[Amount]))

MaxAccountT = CALCULATE(MAX(Table4[Amount]))

Result:

Best Regards,

Lin

[Jaunkalns]

Yes, this is just what I was looking for.

Thank you!