Forum Discussion
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...
i think you can get using following formula:
CurrentQuarter =ROUNDUP(MONTH([TODAY()])/3, 0)
One thing, Today() does not go into brackets.
CurrentQuarter =ROUNDUP(MONTH(TODAY())/3, 0)
That worked out quite well. Thank you!
Phil
Oops that was typo. Thanks thou. Glad we resolved it. :)