Set fixed date for date slicer

[erikm]

I am designing a report that contains a date slicer. Would it be possible to have the from-date automatically set, based on the to-date? For example, when the user selects 06/29/2021 as the end date, I would like to have 01/01/2020 automatically set as the start date, without the ability for the user to change that.

The logic would be, that the from-date is always January 1st of the year before the selected end-date.

Thank you!

[Icey]

Hi @erikm ,

Can this meet your requirements?

StartDate =
VAR SelectedDate_ =
    SELECTEDVALUE ( Dates[Date] )
VAR StartDate_ =
    DATE ( YEAR ( SelectedDate_ ) - 1, 1, 1 )
RETURN
    StartDate_

Measure = 
IF (
    MAX ( 'Data Table'[Date] ) >= [StartDate]
        && MAX ( 'Data Table'[Date] ) <= SELECTEDVALUE ( Dates[Date] ),
    1
)

Best Regards,

Icey

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

[Kumail]

Hello @erikm 

You can do something like this

Measure as filter = 
VAR MonthsToLookBack = 10
VAR DataTableDate = MIN('Data Table'[Date])
VAR DateTableDate = MIN('Dates'[Date])
VAR DateAddAlternative = EDATE(DateTableDate,-MonthsToLookBack)
RETURN
    IF(
        (DataTableDate < DateTableDate)  && 
        (DataTableDate > DateAddAlternative)  ,
        -- FLAG IF TRUE --
        1
        )

If you could send sample .pbix that demonstrate what you are looking to get. It would really help providing you a quick implemented solution.

Hope this helps

Regards
Kumail Raza