Find Largest Value, then pull value in another column based off each portfolio code

HI gmasta1129 ,

You can achieve your goal by creating a new calculated colum using the following DAX:

New Column = 
VAR MaxValue = 
    CALCULATE(
        MAX('Table'[Value]),
        ALLEXCEPT('Table', 'Table'[Portfolio Code Value])
    )
RETURN
    CALCULATE(
        MAX('Table'[Value #2]),
        'Table'[Value] = MaxValue,
        ALLEXCEPT('Table', 'Table'[Portfolio Code Value])
    )

Your table now should look like this:

Hi,

Write this calculated column formula

Column = LOOKUPVALUE(Data[Value #2],Data[Value],CALCULATE(max(Data[Value]),FILTER(Data,Data[Portfolio Code]=EARLIER(Data[Portfolio Code]))),Data[Portfolio Code],Data[Portfolio Code])

Hope this helps.