Forum Discussion
Solved
Using overlapping date periods in a slicer
I am working with dates that belong to multiple 'star ratings' periods. These are the current upcoming periods, they follow the same logic ongoing: Mar25 QTR = 1 Jun 23 to 31 May 24 Jun25 QTR = ...
Hi hanrft
I think you need to create a table where you should include one date in different time periods.
Please check out this video where there is similar kind of requiremnet
https://youtu.be/hDopw1mPlrU?si=rXTDCP9zGBvzjBW3
govind_021
Super User
Super UserHi hanrft
I think you need to create a table where you should include one date in different time periods.
Please check out this video where there is similar kind of requiremnet
https://youtu.be/hDopw1mPlrU?si=rXTDCP9zGBvzjBW3
Thank you! This is exactly what I am looking for in terms of filtering.
Any ideas on how to set up the VAR logic so that I don't need to manually identify which period each date falls into?
If I do as suggested in video this is my formula:
StarRatingsPeriod =
VAR _Mar24QTR = ADDCOLUMNS(
CALCULATETABLE(
'Date',
DATESBETWEEN('Date'[Date],DATE(2023,06,01),DATE(2024,05,31)))
, "Star Ratings Period", "Mar24 QTR")
VAR _Jun24QTR = ADDCOLUMNS(
CALCULATETABLE(
'Date',
DATESBETWEEN('Date'[Date],DATE(2023,09,01),DATE(2024,08,31)))
, "Star Ratings Period", "Jun24 QTR")
RETURN
UNION(_Mar24QTR,_Jun24QTR)