Forum Discussion

psmith-nhs-inc's avatar
psmith-nhs-inc
Icon for Helper III rankHelper 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...
Need Help
  • parry2k's avatar
    parry2k
    9 years ago

    i think you can get using following formula:

     

    CurrentQuarter =ROUNDUP(MONTH([TODAY()])/3, 0)
psmith-nhs-inc's avatar
psmith-nhs-inc
Icon for Helper III rankHelper 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's avatar
parry2k
Icon for Super User rankSuper User
9 years ago
Oops that was typo. Thanks thou. Glad we resolved it. :)