Two Calendar Tables To Control Each Other

Hi, tecumseh 

You can try the following methods. The two date tables do not need to be related.

Measure = 
Var _SELECTEDYear=SELECTEDVALUE(Date1[Date].[Year])
Var _SELECTEDMonth=SELECTEDVALUE(Date1[Date].[MonthNo])
RETURN
IF(MIN(Date2[Date])>=DATE(_SELECTEDYear,_SELECTEDMonth,1)&&MAX(Date2[Date])<=DATE(_SELECTEDYear,_SELECTEDMonth+1,1)-1,1,0)

Place measure in the view to be filtered and set it equal to 1.

Result:

Tested, date slicer does not work when it is in between style. Switching to other styles can work. 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.