Anything related to PowerPivot and DAX Formuale
3 posts • Page 1 of 1
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
Who is online
Users browsing this forum: No registered users and 3 guests