Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

'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 2020M...
daxer-almighty's avatar
daxer-almighty
Icon for Solution Sage rankSolution Sage
5 years ago

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