Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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!
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
78 | |
67 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
83 | |
70 |