cancel
Showing results for
Did you mean:
Frequent Visitor

## 'Same Store' Utilzation

Hi guys,

I'd like to see the growth of 'same store' volume (same store = not including new customers)

I have the following Table Data:

 CUST SAP Number RunYearMonth C17 Volume 111 2020M07 3 112 2020M07 5 111 2021M07 10 112 2021M07 11 113 2021M07 2

Requested Output (in BOLD):

 RunYearMonth YoY Same Store Growth M07 162.5%* M08 ..

* Only using ratio for customers 111+112 as they existed in the previous period. 113 did not exist (new customer).

So calculation is (10+11)/(3+5)-1 = 1.625

thanks guys

3 REPLIES 3
Solution Specialist

Such calculations are easy on condition that your model is correct, which means "built according to Best Practices" (meaning: star-schema). I gather from the picture you sent it's not the case. I'd be glad to help you but you have to have a correct model. Then everyhing becomes EASY. Here's where you could start exploring the world of correct models: Understand star schema and the importance for Power BI - Power BI | Microsoft Docs

Super User IV

@edayan , move year to different table say date (This will work when the year is in the different table only

This Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))

diff = [This Year]-[Last Year ]
diff % = divide([This Year]-[Last Year ],[Last Year ])

Proud to be a Super User!

Frequent Visitor

Hi @amitchandak ,

I'm getting an error with the last year one for some reason..

Any Clue?

Many thanks

Announcements

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

#### The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors