Forum Discussion

Yuiitsu's avatar
Yuiitsu
Helper V
3 years ago
Solved

Create custom quarter

Hi!

 

My company has a different quarter pattern from usual so I need to create a custom quarter column.

 

My company quarter works like this:

Q1 from April 1st to June last day

Q2 From July 1st to September last day

Q3 from October 1st to December last day

Q4 from January 1st to March last day

 

I found in another post something like this:

Company Quarter = SWITCH( TRUE(),
[Date] >= DATE( [Year], 1, 16) && [Date] <= DATE([Year],4, 15), "Q1",
[Date] >= DATE( [Year], 4, 16) && [Date] <= DATE([Year],7, 15), "Q2",
[Date] >= DATE( [Year], 7, 16) && [Date] <= DATE([Year],10, 15), "Q3",
"Q4"
)

 

However I do not know how to change the above to something I can use.

Please help!

 

Thank you.

  • try this:

     

    Company Quarter = SWITCH( TRUE(),
    [Date] >= DATE( [Year], 4, 1) && [Date] <= DATE([Year], 6, 30), "Q1",
    [Date] >= DATE( [Year], 7, 1) && [Date] <= DATE([Year], 9, 30), "Q2",
    [Date] >= DATE( [Year], 10, 1) && [Date] <= DATE([Year], 12, 31), "Q3",
    "Q4"
    )

3 Replies

  • try this:

     

    Company Quarter = SWITCH( TRUE(),
    [Date] >= DATE( [Year], 4, 1) && [Date] <= DATE([Year], 6, 30), "Q1",
    [Date] >= DATE( [Year], 7, 1) && [Date] <= DATE([Year], 9, 30), "Q2",
    [Date] >= DATE( [Year], 10, 1) && [Date] <= DATE([Year], 12, 31), "Q3",
    "Q4"
    )
      • FreemanZ's avatar
        FreemanZ
        Super User

        The approach you have found is a good one, with all the flexibilities. Also learned from that. Thank you as well.