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 "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.

 

 

Need Help

2 Replies

  • 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

  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    5 years ago
    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!