Month to quarter

[MBUser]

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

[MBUser]

Thank you so much!

[slorin · Accepted solution]

Hi, 

each Date.QuarterOfYear(Date.FromText([Month],[Format = "MMMM", Culture="en-US"]))

Stéphane