cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShanayaK Member
Member

Percentage change from quarter to quarter

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

 

 

4 REPLIES 4
Super User IV
Super User IV

Re: Percentage change from quarter to quarter

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
ShanayaK Member
Member

Re: Percentage change from quarter to quarter

Hi @Ashish_Mathur Ashish,

Many thanks for your reply.

 I am using the below data model.

 

DatModel.png

 

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 :

output.png

Please guide me on this.

Thanks.

Super User IV
Super User IV

Re: Percentage change from quarter to quarter

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
ShanayaK Member
Member

Re: Percentage change from quarter to quarter

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.

 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors