Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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:
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:
Yes, this is just what I was looking for.
Thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |