Greg_Deckler
Community Champion
8 years agoQuarter
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.
eyJrIjoiNTA5ZjQ5NTQtMDQ5ZC00MGZjLThkODctMGNiODM5YTYwODVhIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9
No RepliesBe the first to reply