Power Platform Community Forum Thread Details

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

Categories:

Custom Column - combine two query function