Forum Discussion

nataliesmiy1357's avatar
nataliesmiy1357
Helper IV
1 year ago

Custom Date Slicer

Hello!  I am wanting to create a slicer/filter of a date.  I want to create an option of

1) Past 3 months

2) Past 6 months

3) Past 12 months

4) All Data

 

How do I go about doing this?  I wanted to do a relative date filter, but I do not want to show days and weeks.

 

Thanks in advance!

Need Help
Show and Tell
Tutorial Requests

2 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    1 year ago

    Hi nataliesmiy1357 -Please create a calculated column in your date table as below:

    Date Range Filter =
    VAR TodayDate = TODAY()
    VAR Past3Months = EDATE(TodayDate, -3)
    VAR Past6Months = EDATE(TodayDate, -6)
    VAR Past12Months = EDATE(TodayDate, -12)
    RETURN
    SWITCH(
        TRUE(),
        'Date'[Date] >= Past3Months, "Past 3 Months",
        'Date'[Date] >= Past6Months, "Past 6 Months",
        'Date'[Date] >= Past12Months, "Past 12 Months",
        "All Data"
    )

     

     

     

    Hope this helps

     

     

    • nataliesmiy1357's avatar
      nataliesmiy1357
      Helper IV
      1 year ago

      This is a great start!  But I need the Past6Months to include the Past3Months as well - how is that possible?