How to create quarters dynamically from particular year

[sruthi19]

Hi All,

I have to create a Quarter field, from year 2017 in below format. I dont have any date field, how can i generate quarters.

Q1-2017,

Q2-2017,

Q3-2017

.

.

.

Q1-2020

Q2-2020

Q3-2020

Q4-2020

[MayilVahanan]

Hi @sruthi19 

Try like below

Left(YourDateField, 2) as Quarter

[sruthi19]

Hi,

I dont have any date field, i want to generate quarters from Year  2017 by creating a variable.

Quarters:

Q1-2017........Q4-2020

[GaryGiles]

Depending on how you plan to utilize this field, you could use:

ValueList('Q1-2017','Q2-2017','Q3-2017', . . . .,'Q1-2020','Q2-2020','Q3-2020','Q4-2020')

Or you could use a date function within the Valuelist to create Quarter start dates.