Lookupvalue

[miguelsus2000]

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 "NameOfHighestValue" as a DAX function. I used the LookupValue function, but i keep getting an error and wont work. Any help is appreciated.
NameOfHighestValue= lookupvalue(secondtable[name], secondtable[value], max(secontable[value]))

Any guidance will be great. Thank you.

[AllisonKennedy]

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!

[Fowmy]

@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