Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Jaunkalns
Frequent Visitor

Lookupvalue help

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!

1 ACCEPTED SOLUTION
v-lili6-msft
Community Support
Community Support

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:

21.PNG22.PNG

 

Best Regards,
Lin
Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-lili6-msft
Community Support
Community Support

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:

21.PNG22.PNG

 

Best Regards,
Lin
Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Yes, this is just what I was looking for.

 

Thank you!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.