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 ye...
Mahesh0016
3 years agoSuper User
= Table.AddColumn(#"Changed Type", "Year - Quater", each Number.ToText([Year])& " Q"&Number.ToText([Quater]))