Percentage change from quarter to quarter

[Anonymous]

Hi All,

Need ur help in this.

We are using the Date dimention is our data model, Using this how can we drive the following:

Current Quarter

%change from last quarter

% change from last year same quarter

Thanks

[Ashish_Mathur]

Hi,

Create a Calendar Table and build a relationship from the Date column of the Data Table to the Date column of the Calendar Table.  In the Calendar Table, create columns for Year and Quarter.  Drag Year and Quarter to 2 slicers and select any one year and quarter.  Write these measures

Total sales = SUM(Data[Sales])

Total sales in previous quarter = CALCULATE([Total Sales],PREVIOUSQUARTER(Calendar[Date]))

% change over previous quarter = IFERROR([Total Sales]/[Total sales in previous quarter]-1,BLANK())

Total sales in same period last year = CALCULATE([Total Sales],SAMEPERIODLASTYEAR(Calendar[Date]))

% change over same oeriod last year = IFERROR([Total Sales]/[Total sales in same period last year]-1,BLANK())

Hope this helps.

[Anonymous]

Hi @Ashish_Mathur Ashish,

Many thanks for your reply.

 I am using the below data model.

I should not any slicer for Year and Quarter. This should always work with current quarter and Last quarter and the result should be as :

Please guide me on this.

Thanks.

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[Anonymous]

Hi @Ashish_Mathur 

Thanks for looking into it.

Unfortunately, i am not able to upload my file dure to large data size may be.

Would appreciate if you can provide your guidence based on the data model i have shared.

Many Thanks.