Resolution the Problematic of Table

[Anonymous]

I need to calculate within this table the "winners" of the line based on three criteria:
1 - Highest total number of days (if they are equal)
2 - Larger date (if they are still the same)
3 - Higher order

[Anonymous]

In this case, it's not to look for the biggest of all and give only one result, it's to apply the criterion for each type of value of the column "ROW"

[BA_Pete]

Hi @Anonymous ,

You can do this by performing three row selections (filters) in Power Query:

firstFilter =
Table.SelectRows(previousStep, each [Total de Dias] = List.Max(previousStep[Total de Dias]))

secondFilter =
Table.SelectRows(firstFilter, each [Dia Mais Recente] = List.Max(firstFilter[Dia Mais Recente]))

thirdFilter =
Table.SelectRows(secondFilter, each [Maior Ordem] = List.Max(secondFilter[Maior Ordem]))

You may be able to roll this into a single step but this lays out the principle most clearly.

Pete

[Anonymous]

In this case, it's not to look for the biggest of all and give only one result, it's to apply the criterion for each type of value of the column "ROW"

[BA_Pete]

Hi @Anonymous ,

This doesn't make sense to me. Your example output only shows one result.

Can you provide an example of your ACTUAL required output please?

Pete