Ranking based on a minimum list

1

I have a list of dates where I highlight the minimum (earliest date). Now, I need to highlight the date after the minimum.

thisRow.Dates = Min(Table.Dates) → gets my minimum date

2

Hi
you can use :

Table.sort(True(),Table.Dates).nth(2)
3

Tried on my end and it did not work. Can you explain what the code does?

4

Objectif sort table by date ascendant and take second element.

5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.