Forum Discussion
Solved
Filter a column with duplicate values based on the highest Index value
Hello. I am struggling to find a solution for something that I believe should be quite simple. I have a column of values (some of which are duplicates) that I want to filter to show only those wi...
Hi
Group by Ref and choose Max Index
= Table.Group(YourSource, {"Case Ref:"}, {{"Index No.", each List.Max([#"Index No."]), type number}})or
= Table.Sort(
Table.Distinct(
Table.Buffer(
Table.Sort(
YourSource,
{{"Index No.", Order.Descending}})),
{"Case Ref:"}),
{{"Index No.", Order.Ascending}})Stéphane
Hi
Group by Ref and choose Max Index
= Table.Group(YourSource, {"Case Ref:"}, {{"Index No.", each List.Max([#"Index No."]), type number}})
or
= Table.Sort(
Table.Distinct(
Table.Buffer(
Table.Sort(
YourSource,
{{"Index No.", Order.Descending}})),
{"Case Ref:"}),
{{"Index No.", Order.Ascending}})
Stéphane
Thank you, I knew it would be there staring at me right in the face 🙂