topic Re: Lookup value in DAX Commands and Tips

Lookup value

Edmundas — Fri, 16 Dec 2022 12:19:02 GMT

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?

Re: Lookup value

Jihwan_Kim — Fri, 16 Dec 2022 14:19:45 GMT

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] )

Re: Lookup value

Edmundas — Sat, 17 Dec 2022 21:18:20 GMT

It worked perfect! Thank you so much!