Filter based on multiple values within the same column

[rachaelwalker]

The solution I am looking for varies slightly than what I have seen posted on here. I am looking to create a field/measure that I can use as a slicer to filter data based on its age category but I need the filter to be accumulating regarding its age. I would like to filter by the following:

• 3 Months
• 6 Months (I need it to include 3 Months data)
• 12 Months (I need it to include 6 months and 3 months)

Sample data:

Opportunity Number	Stage	Date Closed	Closed Category
11165	Won	null	null
10940	Won	8/17/2023	3 Months
10619	Won	8/14/2023	3 Months
9802	Won	4/26/2023	6 Months
9921	Won	4/24/2023	6 Months
10440	Won	4/21/2023	6 Months
10441	Won	4/19/2023	6 Months
10447	Won	4/18/2023	6 Months
10316	Won	4/18/2023	6 Months
10046	Won	1/25/2023	12 Months
9883	Won	1/4/2023	12 Months
9463	Won	12/28/2022	12 Months
9783	Won	12/19/2022	12 Months
9821	Won	12/14/2022	12 Months
9827	Won	12/13/2022	12 Months
9647	Won	12/5/2022	12 Months
9690	Won	12/5/2022	12 Months
9756	Won	12/5/2022	12 Months
9745	Won	11/30/2022	12 Months
8252	Won	11/28/2022	12 Months
5857	Won	11/22/2022	12 Months
9441	Won	11/18/2022	12 Months
9113	Won	11/16/2022	12 Months

[parry2k · Accepted solution]

@rachaelwalker solution is attached, tweak it as you see fit.