QUARTER function missing....

[Anonymous]

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 functions, ENDOFQUARTER, STARTOFQUARTER etc.... 

What am I doing wrong?

Thanks a lot in advance.

[MFelix · Accepted solution]

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)

[KeyurPatel14]

Hello @Anonymous ,

Kindly restart the PowerBI desktop, it might be a glitch as I can see the QUARTER() function on my machine.