Forum Discussion
Syndicate_Admin
3 years agoAdministrator
Custom Column - combine two query function
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
3 Replies
- AlienSxSuper User
Text.From(Date.Year([MyDate])) & " Q" & Text.From(Date.QuarterOfYear([MyDate])) - Mahesh0016Super User
= Table.AddColumn(#"Changed Type", "Year - Quater", each Number.ToText([Year])& " Q"&Number.ToText([Quater])) - Syndicate_AdminAdministrator
Hi AlienSx,
Thank you very much !!