Forum Discussion
Dynamic Current Quarter Filter
My apologies, I needed to shift the moths a bit. Give this a try:
Current Qtr = VAR _StartOfQtr = DATE ( YEAR ( TODAY() ), FLOOR ( MONTH ( TODAY() ) -1 , 3 ) + 1 , 1 ) VAR _EndOfQtr = EOMONTH ( _StartOfQtr, 2 ) RETURN [Date] >= _StartOfQtr && [Date] <= _EndOfQtr
Hi,
Thank you. This is close however, _StartOfQtr is returning the 1st of September as the start of the quarter resulting in four months instead of the quarter starting on the 1st of October.
My apologies, I needed to shift the moths a bit. Give this a try:
Current Qtr =
VAR _StartOfQtr = DATE ( YEAR ( TODAY() ), FLOOR ( MONTH ( TODAY() ) -1 , 3 ) + 1 , 1 )
VAR _EndOfQtr = EOMONTH ( _StartOfQtr, 2 )
RETURN
[Date] >= _StartOfQtr && [Date] <= _EndOfQtr Perfect thank you!
Hey, is there a way to reuse this for last two quarters? Meaning current + last quarter?
That would look somehting like this.
Current Qtr = VAR _StartOfQtr = DATE ( YEAR ( TODAY() ), FLOOR ( MONTH ( TODAY() ) -1 , 3 ) + 1 , 1 ) VAR _StartOfPQtr = EOMONTH ( _StartOfQtr, -4 ) +1 VAR _EndOfQtr = EOMONTH ( _StartOfQtr, 2 ) RETURN [Date] >= _StartOfPQtr && [Date] <= _EndOfQtr
Hi ,
Even I have the same requirement. But as per my requirement ,I need to calculate " current quarter + Next quarter " sale.
Can you please help me with the formula?
Thnaks in advance
Hello - May I ask for a formula that would return "the current and next 3 Quarters", please?
Thank you!
