Forum Discussion

miguelsus2000's avatar
miguelsus2000
Helper III
5 years ago

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 "...
Need Help
Fowmy's avatar
Fowmy
Super User
5 years ago

miguelsus2000 

Here is the formula to add as a column to firsttable to fetch the name:

NameOfHighestValue =
VAR T1 = 
    FILTER(
        secondtable,
        secondtable[Product]  = firsttable[Product]
    )
VAR __MaxValue =  MAXX(secondtable[Value],T1)
VAR __Name = 
    MAXX(
        secondtable[Name], 
        FILTER(
            secondtable,
            secondtable[Product]  = firsttable[Product] && secondtable[Value] = __MaxValue 
        )
    )
RETURN

__Name

 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn