How to add "Q" before the Quarter of a year?

[luna_]

I would like to get the quarter of a year out of a date column and add a "Q" in front of it.
I manage to do the first bit by using the following: Number.RoundUp(Date.Month([#"Arrival Date"])/3,0)).
I know it works because I get the correct results:

But when I add the letter Q it causes errors:

[serpiva64 · Accepted solution]

Hi,

You have to use Text.From

try

"Q"&Text.From(Number.RoundUp(Date.Month([Column1])/3,0))

If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!