FORMAT - Add a q in front of the quarter number

[agd50]

(How it looks like in a chart)

How can I add a q after the year and before the q number? I have tried "&Q" which didn't work and QQ also didn't work.

Regards,
Andrew

[FreemanZ · Accepted solution]

hi @agd50 

try like:

Column = YEAR([Date])&" Q"&QUARTER([Date])

[agd50]

Incredible!! Works perfectly, IQ level over 1000