I am adding a column to get the quarter number, which I understand. I have as:
= Table.AddColumn(#"Added Custom2", "QTR", each Date.QuarterOfYear([Package Effective Date]))
However, I would like each to have 'QTR' also next to the number. So:
QTR 3
QTR 2
QTR 2
...
How would I edit to also include the text?
Thanks
= Table.AddColumn(#"Added Custom2", "QTR", each Date.QuarterOfYear([Package Effective Date]))
However, I would like each to have 'QTR' also next to the number. So:
QTR 3
QTR 2
QTR 2
...
How would I edit to also include the text?
Thanks