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
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
Hi
you can use :
Table.sort(True(),Table.Dates).nth(2)
Tried on my end and it did not work. Can you explain what the code does?
Objectif sort table by date ascendant and take second element.