Choosing Dates Across Tables with no Relationship

[Anonymous]

Hello All,

I have two tables. the first table contains a lost of projects with specific milestones and their associated dates.

Ex:

Project	Milestone	Date
ABC	X0	1/1/2021
ABC	X1	3/1/2021
ABC	X2	5/1/2021
ABC	X3	7/1/2021
DEF	X0	2/1/2021
DEF	X1	2/15/2021

The second table consists of meeting dates.

Meeting Date

12/1/2020

1/15/2021

2/15/2021

3/1/2021

4/15/2020

The problem I have to solve is to show, for each milestone, the meeting date that takes place at least 2 weeks prior to that milestone date. Thanks in advance for anyone who can help!

[amitchandak · Accepted solution]

@Anonymous , Try a new column in table 1

maxx(filter(table2, Table2[Date] <Table1[Date] -14 ), Table2[Date])

[Anonymous]

Thank you @amitchandak ! That's perfect!