Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Custom Period Date for 2 years

Hi,

I have been tasked with making a dashboard for work. I have been given a large data set of tickets, with open and closed dates. The plan is to merge all of this data and figure out how many tickets have been opened/closed within each period - however this is two years worth of data, so 26 periods in total.

 

What is the best way to get these periods into the dashboard, and how to work out a relationship between these random dates and to make them know they belong in a certain period? e.g. ticket was closed 01/02/2021 so will be in Period 2... but how can I get it to know that?

Any help or guidance is appreciated!

 

Thank you, 

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    Anonymous Create a custom calculated column in Power Query or DAX that specifies which period each belongs to. I don't know the business rules so hard to be more specific.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Greg,

      Thanks for your response - for a bit more clarity, I currently have this table in my Excel (which will be used for the dashboard): 

       

      With the plan being for these type of tickets to know which period they belong to:

      Do you happen to know what type of Power Query/DAX would work with this? Feeling out of my depth!

      Thanks so much,