Determine closest date in PowerQuery

[INPEXPERTH]

Hi,

I have two sets of dates:

Approval date is when a paper is ready for submission to Team review.

Approval date

7/09/2024

6/12/2024

4/09/2024

Team meetings are every fortnight as below. 

Team Meeting dates

7/08/2024

21/08/2024

4/09/2024

18/09/2024

2/10/2024

16/10/2024

30/10/2024

13/11/2024

27/11/2024

27/11/2024

11/12/2024

Based on the Approval date, I would like to find a Team Meeting date that is the closest to approval date.

Approval date	Team Meeting date
7/09/2024	18/09/2024
6/12/2024	11/12/2024
4/09/2024	04/09/2024

I have tried to use the List.Min but it does not seem to work with Dates.

Appreciate any ideas!

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.