Forum Discussion
Anonymous
3 years agoNot applicable
Month to quarter
Hi
I am trying to add a column which will give me the quarter.
Under the month column, I have January, February, March, April up to December.
I want to add a column which will give me which quarter does these months fall. i.e. January will be Q1.
Thanks
Hi,
each Date.QuarterOfYear(Date.FromText([Month],[Format = "MMMM", Culture="en-US"]))
Stéphane
2 Replies
- slorinSuper User
Hi,
each Date.QuarterOfYear(Date.FromText([Month],[Format = "MMMM", Culture="en-US"]))
Stéphane
- AnonymousNot applicable
Thank you so much!