Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

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 ye...
AlienSx's avatar
AlienSx
Icon for Super User rankSuper User
3 years ago
Text.From(Date.Year([MyDate])) & " Q" & Text.From(Date.QuarterOfYear([MyDate]))