Selected Quarter versus Previous Quarter Calculation

[sreeramhbk]

Hi Guys,

I have a requirement to create a KPI chart which shows the selected Quarter with previous Quarter. I have done successfully for MOM and YOY with the following formulaes':

MoM:

Sum({$<[Business Date.autoCalendar.Month]={$(=Month(((Max(Date([Order_Date],'MM/DD/YYYY'))))))}>}[Sales]) -

Sum({$<[Business Date.autoCalendar.Month]={$(=Month((AddMonths(Max(Date([Order_Date],'MM/DD/YYYY')),-1))))}>}[Sales])

YoY:

Sum({$<[Business Date.autoCalendar.Year]={$(=Year(((Max(Date([Order_Date],'MM/DD/YYYY'))))))}>}[Sales])-

Sum({$<[Business Date.autoCalendar.Year]={$(=Year((AddYears(Max(Date([Order_Date],'MM/DD/YYYY')),-1))))}>}[Sales])

But with the same approach I am not able to calculate the Selected Quarter vs Previous Quarter. Please assist. 

Many thanks.

Kind Regards,
Sreeram

[Sabiha]

Hi

did you solve the problem?  Could you help?  

[Sabiha]

Hi

sorry I don't speak  English 

may be useful

year(FATURALAMA_TARIHI)&ceil(FATURALAMA_TARIHI/3) as Quarters

if(right( Quarters,1)='1', Sum({$<Quarters={$(=only(Quarters)-7)}>} NET_MIKTARS), Sum({$<Quarters={$(=only(Quarters)-1)}>} NET_MIKTARS))

[Sabiha]

sorry

year(FATURALAMA_TARIHI) & Ceil(Month(FATURALAMA_TARIHI)/3) as Quarters,