Lookup value

[Edmundas]

Hi there,

I have a table with employee's name and his/her position and need to write formula to get results as it is shown in column 'Position_Full'. Lookupvalue didn't work.. Any help please?

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Position_Full CC = 
VAR _currentname = 'Table'[Name]
VAR _lookuptable =
    SUMMARIZE (
        FILTER ( 'Table', 'Table'[Position] <> BLANK () ),
        'Table'[Name],
        'Table'[Position]
    )
RETURN
    MAXX (
        FILTER ( _lookuptable, 'Table'[Name] = _currentname ),
        'Table'[Position]
    )

[Edmundas · Accepted solution]

It worked perfect! Thank you so much!

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Position_Full CC = 
VAR _currentname = 'Table'[Name]
VAR _lookuptable =
    SUMMARIZE (
        FILTER ( 'Table', 'Table'[Position] <> BLANK () ),
        'Table'[Name],
        'Table'[Position]
    )
RETURN
    MAXX (
        FILTER ( _lookuptable, 'Table'[Name] = _currentname ),
        'Table'[Position]
    )