Dynamic date range selection

Hi,

I am not sure whether I understood your question correctly, but please check the below picture and the attached pbix file. I do not know how your data model looks like, but I tried to create a sample pbix file like below, and I hope the below can give some ideas on how to apply a similar calculated measrue to your data model.

Quantity desired outcome: = 
VAR _prioroneyearrange =
    DATEADD ( 'Calendar'[Date], -1, YEAR )
VAR _priortwoyearrange =
    DATEADD ( 'Calendar'[Date], -2, YEAR )
VAR _priorthreeyearrange =
    DATEADD ( 'Calendar'[Date], -3, YEAR )
VAR result =
    CALCULATE (
        SUM ( Data[Quantity] ),
        KEEPFILTERS ( FILTER ( ALL ( Data ), Data[Date] IN _prioroneyearrange ) )
    )
        + CALCULATE (
            SUM ( Data[Quantity] ),
            KEEPFILTERS ( FILTER ( ALL ( Data ), Data[Date] IN _priortwoyearrange ) )
        )
        + CALCULATE (
            SUM ( Data[Quantity] ),
            KEEPFILTERS ( FILTER ( ALL ( Data ), Data[Date] IN _priorthreeyearrange ) )
        )
RETURN
    result

Anonymous , You can not default range slicer. You can use relative date slicer or a work around default column like

Year Type = Switch( True(),
year([Date])<= year(Today()) && year([Date])>= year(Today())-3,"Last 3 Years" ,
Format([Date],"YYYY")
)

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA

Hi Amit,

This scenario wouldn't helped me out 

-Francis

Hi Anonymous ,

Whether the advice given by Jihwan_Kim  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry