Power Query Exact match or next smaller item

[AdamPolak96]

Hi,

I searching for solution to get the same result like funticion in excel xlookup,
but i want the same result like in power pivot. 
 

Below function in PL

[slorin]

Another possibility

try Table.SelectRows(Rating_Table, (x) => [RATING SCALE] >= x[RATING SCALE])[GRADE]{0} otherwise "F"

Stéphane

[slorin · Accepted solution]

Hi

Add new column

try Rating_Table[GRADE]{List.PositionOf(Rating_Table[RATING SCALE],[RATING SCALE],1,(x,y)=>x>y)+1} otherwise "F"

Stéphane