Slicer for fixed date periods

[Sean2]

Hello. I'm looking to make a slicer that has a list of specific date ranges. Instead of the regular year hiarachy like this (Jan 1st - Dec 31st)

Year

•  2024
•  2023
•  2022

I'm trying to get a list I can use to filter all my visuals based on non calendar years. So each choice would start July 1st going through June 30th of the next year (or maybe just Sept - April) . Something like this

Snow Season

• 2023-2024 Season
• 2022-2023 Season
• 2021-2022 Season

I have been playing around with the DATESBETWEEN formula but it's not getting me what I want.

Thanks for any ideas you might have!

[jdbuchanan71 · Accepted solution]

@Sean2 

You could add a column like this to your calendar table.

Snow Season =
IF (
    MONTH ( [Date] ) >= 7,
    YEAR ( [Date] ) & "-" & YEAR ( [Date] ) + 1 & " Season",
    YEAR ( [Date] ) - 1 & "-" & YEAR ( [Date] ) & " Season"
)

You can see, on July 1st it flips to the new year.