Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Resolution the Problematic of Table

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 - Highe...
Need Help
BA_Pete's avatar
BA_Pete
Super User
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      BA_Pete
      Super User
      4 years ago

      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