Custom Date Slicer

[nataliesmiy1357]

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!

[rajendraongole1]

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]

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