Forum Discussion
Anonymous
2 years agoNot applicable
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 ...
- 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)
KeyurPatel14
2 years agoResponsive Resident
Hello Anonymous ,
Kindly restart the PowerBI desktop, it might be a glitch as I can see the QUARTER() function on my machine.