topic Re: Selected Quarter versus Previous Quarter Calculation in App Development

Selected Quarter versus Previous Quarter Calculation

sreeramhbk — Sat, 16 Nov 2024 20:54:45 GMT

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

Re: Selected Quarter versus Previous Quarter Calculation

Sabiha — Tue, 22 Oct 2019 05:35:09 GMT

did you solve the problem? Could you help?

Re: Selected Quarter versus Previous Quarter Calculation

Sabiha — Tue, 22 Oct 2019 07:04:06 GMT

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))

Re: Selected Quarter versus Previous Quarter Calculation

Sabiha — Tue, 22 Oct 2019 07:05:43 GMT

sorry

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