Forum Discussion
Determine closest date in PowerQuery
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!
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
1 Reply
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.