Chart with datesbetween

Hi nuriac 

I think you need to get the result between select month +-3 by two Slicer (Year and Month)

I build a sample to have a test.

Build a calendar table.

Calendar = ADDCOLUMNS(CALENDARAUTO(),"Year",YEAR([Date]),"Month",MONTH([Date]))

Build two slicers by year and month column in calendar table.

Then build a measure:

Measure = 
VAR _Y = SELECTEDVALUE('Calendar'[Year])
VAR _M = SELECTEDVALUE('Calendar'[Month])
VAR _SELDATE = DATE(_Y,_M, 1)
VAR _MAXDATE = EOMONTH(_SELDATE,+3)
VAR _MINDATE = EOMONTH(_SELDATE,-4)+1
RETURN
IF(MAX('Table'[Date])>=_MINDATE&&MAX('Table'[Date])<=_MAXDATE,1,0)

Drag the measure into the Filter field in this table visual and set it show items when value = 1.Result is as below.

As default it will show blank and  when you select Year = 2020, Month =3.

You can download the pbix file from this link: Chart with datesbetween

Best Regards,

Rico Zhou

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