Forum Discussion
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 1s...
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")
