Date filtering and relationship

Hi， hgalfre ；

There are two methods:
1.One is to create many-to-many relationships between dates in "Actual Sales table" and "Actual Target table", and delete other relationships or make them inactive.

The final output is shown below:

2.The second method is to join the date inactive relationship between the two tables and create the measure using USERELATIONSHIP().

Then create a measure.

sale2 = CALCULATE(SUM('Actual sales table'[Sales]),USERELATIONSHIP('Actual sales table'[Date],'Actual target table'[Date]))

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.