Excel BI Challenge Workout 191

Workouts Excel BI Challenge
21

LinkedIn Post by:
Kris Jaganah

=LET(a,A2:A6,b,SORT(HSTACK(a,BYROW(B2:D6,LAMBDA(x,SUM(x)))),2,-1),c,TAKE(b,,1),XLOOKUP(a,c,XMATCH(c,c)))

22

LinkedIn Post by:
Sunny Baggu
 

=XMATCH(A2:A6,SORTBY(A2:A6,BYROW(B2:D6,LAMBDA(a,SUM(a))),-1))
23

LinkedIn Post by:
Krzysztof Nowak

My solution in hashtag#R

image
image730×680 95.1 KB

24

LinkedIn Post by
Nicolas Micot
 

=LET(_ranks;BYROW(B2:D6;LAMBDA(a;TEXTE(SOMME(a);"000")));
_ranksPlus;_ranks&"_"&TEXTE(10000-LIGNE(A2:A6);"00000");
_tri;TRIER(_ranksPlus;;-1);
BYROW(_ranksPlus;LAMBDA(a;EQUIV(a;_tri;0))))
25

LinkedIn Post by:
Amr Tawfik, CMA P1

=XMATCH(A2:A6,SORTBY(A2:A6,BYROW(B2:D6,LAMBDA(x,SUM(x))),-1),0)

26

Answer:
Hi.

Power M query in the Excel file

let
Source = Excel.CurrentWorkbook(){[Name=“Table1”]}[Content],
AddSum = Table.AddColumn(Source, “Sum”, each List.Sum({[Round 1],[Round 2],[Round 3]})),
AddIndex = Table.AddIndexColumn(AddSum, “Index”, 1, 1, Int64.Type),
SortSum = Table.Sort(AddIndex,{{“Sum”, Order.Descending}}),
Expected = Table.AddIndexColumn(SortSum, “Expected”, 1, 1, Int64.Type),
SortAddIndex = Table.Sort(Expected,{{“Index”, Order.Ascending}}),
Results = Table.SelectColumns(SortAddIndex,{“Expected”})
in
Results

thanks for the workout.
Keith