Custom Column - combine two query function

[Syndicate_Admin]

Hi,

I have a standard date column named "MyDate"

I want to create a custom column with year + quarter number,  like: 2023 Q1

If I use this, it is working well: Date.Year([MyDate])  I am getting year number in my "MyQuarter"  column

this is also fine: Date.QuarterOfYear([MyDate])       again  I am getting quarter number in my "MyQuarter"  column

but the combination not: 

Date.Year([MyDate]) & " Q" & Date.QuarterOfYear([MyDate])

where I am doing a mistake

Thank you for your help

[Syndicate_Admin]

Hi AlienSx,
Thank you very much !!

[Mahesh0016]

@Syndicate_Admin 

= Table.AddColumn(#"Changed Type", "Year - Quater", each Number.ToText([Year])& " Q"&Number.ToText([Quater]))

[AlienSx]

Text.From(Date.Year([MyDate])) & " Q" & Text.From(Date.QuarterOfYear([MyDate]))