Forum Discussion
Solved
Power Query Exact match or next smaller item
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
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
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