Forum Discussion
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 functions, ENDOFQUARTER, STARTOFQUARTER etc....
What am I doing wrong?
Thanks a lot in advance.
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)
2 Replies
Hello Anonymous ,
Kindly restart the PowerBI desktop, it might be a glitch as I can see the QUARTER() function on my machine.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)
