Forum Discussion
Solved
Values with the highest mark
Hi I have a table like this: Ref. No. Evaluation Value A 5 2 A 4 3 A 7 3 B 6 2 B 5 3 B 3 3 B 4 2 My goal is to group this data based on its maximum...
Hi
let
Source = YourSource,
Sort = Table.Sort(Source,{{"Evaluation", Order.Descending}}),
Distinct = Table.Distinct(Sort, {"Ref. No."})
in
DistinctStéphane
Hi
let
Source = YourSource,
Sort = Table.Sort(Source,{{"Evaluation", Order.Descending}}),
Distinct = Table.Distinct(Sort, {"Ref. No."})
in
Distinct
Stéphane