Dynamic date range selection

[Anonymous]

Hi All,

Example:- If the user chooses the date range slicer 03/1/2022 - 04/01/2022, make the table show the same date range for the prior 3 years, how should I make it.

Need your help!

Thanks,

Francis

[v-henryk-mstf]

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

[Jihwan_Kim]

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]

Still I'm not getting the desired output , Thank you

[Anonymous]

Hi Amit,

This scenario wouldn't helped me out 

-Francis

[amitchandak]

@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