Create drop down selection for measure

[Roym]

I have a table which shows movement during a quarter. for example:

Issue	Created	Due	Closed
Name 1	Q1 2023	Q4 2023	Q1 2024
Name 2	Q2 2023	Q3 2023

Now I created a quick measure which is set to 'Q3 2023'.  Based on that measure I have a couple of calculated columns that show if the issue is new, due, closed during this quarter. This works perfectly this way, but the measure to select the quarter (Q3 2023) in this case is hard-coded. What I would like is a slicer/drop down that you can select the quarter and based on that the measure is set to that, which calculated the new, due, closed. Any idea how I can achieve this?

[v-zhangti]

Hi, @Roym 

Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. I look forward to your response.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Roym]

When I was trying to make my question clearer I got it fixed haha. Needed to just create a new table that has all the dates, then these can be used to filter.