Forum Discussion

Helper III

9 years ago

Solved

How do I determine Current Quarter?

CMisCurrentMonth = if('Date'[MonthNumber] = Month(Today()),"CM",'Date'[Month]) This gives me a slicer/filter where current month is always selectable by selecting "CM". CYisCurrentYear = if('Dat...

parry2k
9 years ago
i think you can get using following formula:

CurrentQuarter =ROUNDUP(MONTH([TODAY()])/3, 0)

Super User

9 years ago

i think you can get using following formula:

CurrentQuarter =ROUNDUP(MONTH([TODAY()])/3, 0)

psmith-nhs-inc
Helper III
9 years ago
One thing, Today() does not go into brackets.

CurrentQuarter =ROUNDUP(MONTH(TODAY())/3, 0)

That worked out quite well. Thank you!

Phil
- parry2k
  Super User
  9 years ago
  Oops that was typo. Thanks thou. Glad we resolved it. :)
- Anonymous
  Not applicable
  4 years ago
  If i use this, current Quarter number is showing in all the rows.
  
  How to create column which has current Quarter as "Current Quarter", then rest is same like normal Quarter to be use for slicer (for default selection need to be current quarter)
  - PhilSmith
    Helper III
    4 years ago
    My Date table comes from a spreadsheet. This allows me to add my companies holidays into the mix for working day calculatoins and such.
    
    I created a calculated column to identify if any particular date is in the current quarter. If it is, I get "CQ". If it is not, than I get Q1, Q2, Q3, or Q4 as expected.
    
    CQisCurrentQuarter =
    IF ( ROUNDUP ( MONTH ( TODAY () ) / 3, 0 ) = 'Date'[QuarterNumber], "CQ", 'Date'[Quarter] )
    
    Hope that helps.
    
    Phil