Power query

[Snehal_123]

Hi, 
I am stuck with a problem with the power query.
Scenario: I want to display the name of the employee with the highest percentage in a CARD visual.

Table name: sheet2

Columns: name, correct answer, incorrect answer, percentage, and so on.

[DOLEARY85 · Accepted solution]

Hi,

Not sure about doing this in power query, it sounds like you want a measure to do this, in which case you can use:

Measure = LOOKUPVALUE('sheet2'[name],'sheet2'[percentage],MAX('sheet2'[percentage]))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍