Forum Discussion

Helper II

6 years ago

Solved

Select max value for a group based on another column

Hi, Lookin as the following table: TableA: id value key 1 a 1 1 b 2 1 c 3 2 a 4 2 d 5 2 f 6 how can I write a formula for a column in another table (re...

Need Help

rylach
6 years ago
Looking for examples of MAXX+RELATEDTABLE I found the solution, didn't know LOOKUPVALUE accepts more than one key/value pairs:

https://community.powerbi.com/t5/Desktop/Value-associated-with-a-Max-in-a-related-table-with-grouping/m-p/44856/highlight/true#M17351

Greg_Deckler

Community Champion

6 years ago

rylach - Use MAXX along with RELATEDTABLE.

rylach

Helper II

6 years ago

Looking for examples of MAXX+RELATEDTABLE I found the solution, didn't know LOOKUPVALUE accepts more than one key/value pairs:

https://community.powerbi.com/t5/Desktop/Value-associated-with-a-Max-in-a-related-table-with-grouping/m-p/44856/highlight/true#M17351

Forum Discussion

Select max value for a group based on another column

Related content

Sort by another column

Find Most Recent Date Relative to another Date Column in Power Query

Yet another Sort by another Column error.

slicers automatically selected based on another slicer selection

[PowerQuery] add (same) column from another table