Forum Discussion
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 wante...
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
This is a great start! But I need the Past6Months to include the Past3Months as well - how is that possible?
