Setting Between date slicer

[bhavaniIntMaven]

Current Scenario: Between date slicer is setting to specific date (lets suppose 1st jan to 1st march) on clicking CLEAR ALL button.

Requirement: If we check tomorrow i.e. 2nd march and do clear all then the date slicer should slide to 2nd march instead of 1st march ( 1st jan to 2nd march).

please advise.

[Sahir_Maharaj · Accepted solution]

Hello @bhavaniIntMaven,

Can you please try this:

IsWithinRange = 
IF (
    AND (
        'DateTable'[Date] >= DATE(YEAR(NOW()) - 1, 1, 1),
        'DateTable'[Date] <= NOW()
    ),
    1, 
    0
)