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 - Higher order

 

 

Need Help

4 Replies

  • 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

  • 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"