Power Query - Lookup value between dates in a separate table

I have two tables in Power Query that have no relationships between them.    Main Table Date Team Qty CY 6/1/2022 A1 100   7/15/2021 B1 200   8/30/2022 B2 300     Co...