Comparing Quarters

[mariamovasheli]

Hi,

I need To compare Quarters Like 2018 quarter to 2017 4th Quarter.

Sum({< Year={'$(=max(Year))'}, QuarterNum={"<=$(=(max(QuarterNum)))"}>}Volume)

That is Formula  For 2018 Quarter and How can I calculate 2017 4th quarter?  Can you Please Help me

[brunobertels]

Hi

Try this

Sum({< Year={'$(=max(Year)-1)'}, QuarterNum={"<=$(=(max(QuarterNum)))"}>}Volume)

[arulsettu]

may be like this

Sum({< Year={'$(=max(Year))'}, date={">=$(=Num(MonthStart(Max(date), -14)))<=$(=addmonths(Max(date), -11))"}>}Volume)

in second part will give you the Q4 from 2017. change the number inside the set to control the month.

[Anil_Babu_Samineni]

What is the format of QuarterNum ??

[mariamovasheli]

Integer, And I need This Formula To change when I select q3 of 2017 to compere it with q2 of 2017