cancel
Showing results for 
Search instead for 
Did you mean: 

Quarter

Super User
419 Views
Super User
Super User

Quarter

Sometimes you need the Quarter number and no, you don't have an automatic date hierarchy to work with.

 

 

Quarter = ROUNDUP(MONTH(MAX('Calendar'[Date]))/3,0)

Takes a single input, the [Date] column from a table.

 

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!