Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am hoping for some assistance in creating a YTD same store growth calculation. The goal is to see how stores are growing that were open in both the prior and current year.
The dax calculation I have right now is below. This works great for individual periods (we measure in weeks on a 4-4-5 calendar) as it looks to see if there is revenue in the current and prior year period and if so includes it in the calculation to determine growth.
Hi @nickvb ,
here because there is no data given i'm using 'table' and some column names. Please replace them with the actuals ones.
Please use the below formula :
SAME PERIOD LAST YEAR = VAR DataMaxDate = CALCULATE ( MAX ( 'Table'[Date.Date].[Date] ), ALL ('Table' ) ) RETURN CALCULATE ( [YTD Sales], SAMEPERIODLASTYEAR ( INTERSECT ( VALUES ('Table'[Date.Date].[Date] ), DATESBETWEEN ( 'Table'[Date.Date], BLANK (), DataMaxDate ) ) ) )
NOTE : make sure to change Date column to date type otherwise you will end up with the same issue you are facing.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
Regards,
Gaurav Raj Singh
LinkedIN : https://www.linkedin.com/in/gauravrajsingh/
User | Count |
---|---|
50 | |
24 | |
18 | |
17 | |
14 |
User | Count |
---|---|
91 | |
84 | |
39 | |
25 | |
21 |