Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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

  • Hi, 

     

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

     

    Stéphane 

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thank you so much!