Forum Discussion
Solved
Simple Growth Measure
I have the following data that I would like to do a growth % for: Year Totals Case Type Year End 2017 1420 Intake 31/12/2017 2018 1520 Intake 31/12/2018 2019 1358 Inta...
STIBBS_807 Do you have a DimDate table? https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html
Time Intelligence is MUCH easier with a date table.
Follow the instructions in my blog if you don't have one, then try these measures:
Total Value = SUM('TABLE NAME'[Totals])
PY Total Value = CALCULATE ( [Total Value] , DATEADD( DimDate[Date], -1, YEAR) )
% Growth Totals = DIVIDE( [Total Value] - [PY Total Value], [PY Total Value] )
Make sure you use that % Growth within the context of a Year or date slicer/visual.
Thank you. I do have a DimDate table set up. I will try your solution and let you know if it works for me.