Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

QUARTER function missing....

Hi.   I am trying to calculate quarter number based on Today and also add a quarter column in my date table. However, I don't have the QUARTER function available. I have all other kinds of quarter ...
  • MFelix's avatar
    2 years ago

    Hi Anonymous ,

     

    Not sure why you don't have the quarter but you can simply make the following calculation to get the value of the Quarter:

     

    ROUNDUP(MONTH(TODAY())/3,0)
    
    or
    
    
    ROUNDUP(MONTH(Table[Date])/3,0)