Forum Discussion
Lookupvalue
Hi, I created a "MaximumValue" column on my first able which pulls the highest "Value" from the second table for a specific Product. However, i also want to add a column to my first table called "...
How are tables 1 and 2 related? Is it a 1 to many?
You could try using the MAXX function:
MAXX(FILTER(Table2, Table2[Product] = Table1[Product] && Table2[Value]=Table1[MaximumValue]), Table2[Name])
If that doesn't work, please provide sample data we can copy easily and screenshot of relationship and error you're getting.
Cheers!
You could try using the MAXX function:
MAXX(FILTER(Table2, Table2[Product] = Table1[Product] && Table2[Value]=Table1[MaximumValue]), Table2[Name])
If that doesn't work, please provide sample data we can copy easily and screenshot of relationship and error you're getting.
Cheers!