Creating a mapping table based on date completed

123abc , I really appreciate your response.  Unfortunately, the above is not working for me.  If I try the statement as you wrote it but with my table names and columns, I get a syntax error because it can't find the 2nd table.

I know how I would do this in a non-DAX world: I would loop through all rows in the status report table, then for each row in that table find all the matches in the customer board table based on what falls in the date range.  But I can't wrap my head around how to do this in DAX.  I would also be up for doing this in Power Query M if that would be easier.  The big reason I need to have this mapping table is that a single row from the customer board table could appear in multiple status reports, depending on a date range.  For instance, you could make a monthly status report then a quarterly one, expecting the board item to show up on both.  Make sense?