Quarter on Quarter Growth

[Anonymous]

Hi,

I would like to calculate QoQ sales growth . I have two seperate Dashboards one covering the nomral Calendar Jan - Dec and the other covering Fiscal Year  Jul - Jun.

I have date tables for each dashboard that reflects the calander type for the respective dashboard, therefore my quarter numbers in my dates table are reflected accordingly (Jan-March Q1 etc and Jul-Sep Q1 etc).

How do I then calaculate QoQ growth between each quarter for both calendars for example 10% increase from Q1 to Q2 etc.

Any help would be much appreciated.

[v-yalanwu-msft · Accepted solution]

Hi， @Anonymous ；

According to your description, I made a simple file:

1. Create a column to calculate a year-quarter.

nomral-Qua = [Date].[Year]&"-"& [Date].[QuarterNo]

Fiscal-Qua = YEAR( EOMONTH([Date],-6))&"-"&QUARTER( EOMONTH([Date],-6))

2.create a measure to calculate a grow percentage.

Grow% = 
var _pre=CALCULATE(SUM([Sale]),FILTER(ALL('financials'),[nomral-Qua]= MAXX(FILTER(ALL('financials'),[nomral-Qua]<MAX('financials'[nomral-Qua])),[nomral-Qua])))
return DIVIDE( SUM([Sale])-_pre,_pre)

The final output is shown below:

If this formula does not apply to your data, can you share some scenarios and want to output results about your data？Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VijayP]

@Anonymous 

If first place, I request you to call them as Reports but not Dashboards , since Dashboard is some thing different.
in case of QoQ variance you need to find the previous quarter number 

use CALCUALTE(Measure,DATEADD(DateDim[Date],-1,QUARTER)) and subtract this from the Regualar [Measure]

Hope this helps you!