Calculating Same Store Growth Rate

Anything related to PowerPivot and DAX Formuale
amit.kadoo
Posts: 2
Joined: Thu Jan 14, 2016 3:43 pm

Calculating Same Store Growth Rate

Postby amit.kadoo » Thu Jan 14, 2016 3:54 pm

Same Store Growth Sample.xlsx
Same Store Growth Sample File
(987.7 KiB) Downloaded 209 times


Hi Matt,

As suggested by you posting a sample workbook for the problem I am facing in relation to calculating the same store growth rate.

Reproducing the problem faced -
If i use AddColumn & Summarize method then the data in SSG column also includes rows (i.e months) which did not have sales (either in current year or previous year or both years). The calculated value is -1 (or -100%). Field Name "SSG 1" in the workbook.

If i use the nested SumX method the table is filtered properly i.e. only those rows are visible where there was sales in current year as well as previous year. However the calculation in to row total is summation of individual SSG for months rather than the difference between the like to like sales of the 2 year. Field Name "SSG 2" in the workbook.

For ease I have created a sheet ideal output to show ideal output and have copied & highlighted the problem using the 2 formulas.

Thanks in advance
Amit

MattAllington
Posts: 1062
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Calculating Same Store Growth Rate

Postby MattAllington » Mon Jan 18, 2016 7:57 am

Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

amit.kadoo
Posts: 2
Joined: Thu Jan 14, 2016 3:43 pm

Re: Calculating Same Store Growth Rate

Postby amit.kadoo » Tue Jan 19, 2016 4:26 pm

Thanks a ton Matt. This works perfectly.


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 3 guests