Forum Discussion

unnijoy's avatar
unnijoy
Post Prodigy
6 years ago

Quarter table

Please help to create a table with the below criteria.

 

I have a Month Column in my tables. From this i need creatre another table with Quarter and sort it in Descending Order.

 

My Q1 is from December - February. Like this i have to create the Quarter.

 

Please help to create a table like this. 

Need Help

8 Replies

  • dobregon's avatar
    dobregon
    Impactful Individual
    6 years ago

    As i see your quarters are not following the normal division in a year, in any case there are only 4 quarters so you can create a simply column calculated with IF

    QuarterNum = IF( (Month = 12 || Month = 1 || Month = 2 ), 1, IF( (Month = 3 || Month = 4 || Month = 5 ), 2, IF( (Month = 6 || Month = 7 || Month = 8 ),3,4)))

     

    • unnijoy's avatar
      unnijoy
      Post Prodigy
      6 years ago

      Hi dobregon ,

       

      thanks for your quick reply.

       

      Can you please help me to get this in the format like QTR 1 - 2020. And when we use this in graph can we sort it like Latest quarter will come first.

      • amitchandak's avatar
        amitchandak
        Super User
        6 years ago

        unnijoy , Try Like

        Create a new column like, hope you have qtr no,

        Qtr Name = "QTR " & [Qtr No] & " - " & [Year]

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    6 years ago

    Hi unnijoy 

     

    If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!