Dax Table Filterting

Hello all, I have a table like so: I have connected it to a date table all the start and thru columns on the right side are connecting to the Date column on the left: And I crea...

Need Help

jeronimo2334

Helper III

5 years ago

Attached some sample data:
I have Table 1 and Table 2. What I would like to do is in Table 1 attach a new column with the giveName column from Table 2. The tricky part is that the records need to match on these criteria:
PostedDate of Table 1 is less or equal from the date columns in Table 2 that have the "Start" prefix
and
PostedDate of table 1 is greater or equal from the "Thru" date columns or the "Thru" columns are null.

If there are more that 1 records that match, I'd like to concatane the names by a comma if possible.

Table 1:

https://www.dropbox.com/s/qx8vvofcwqle5uq/table1.xlsx?dl=0

Table 2:
https://www.dropbox.com/s/pshwj3a3j4qdwst/table2.xlsx?dl=0