Limit Range of Date Slicer

[EBGAL]

Hi,

I want to limit a date slicer to display only dates 4 years before today and 3 months ahead.

I did it using #duration in Power Query where I create a logical column, but thought DAX might have a good solution, too.

Thanks

Evan

[amitchandak · Accepted solution]

@EBGAL , You can control calendar of have a flag

new column

Flag = if([Date] >= date(year(Today())-4,1,1) && [Date] <=  eomonth(today(),3) , 1, 0)