Forum Discussion

Roym's avatar
Roym
Helper IV
2 years ago

Create drop down selection for measure

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

 

IssueCreatedDueClosed
Name 1Q1 2023Q4 2023Q1 2024
Name 2Q2 2023Q3 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?

Need Help

2 Replies

  • v-zhangti's avatar
    v-zhangti
    Community Support
    2 years ago

    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's avatar
      Roym
      Helper IV
      2 years ago

      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.