Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

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.

 

 

No RepliesBe the first to reply