Forum Discussion
Simple Growth Measure
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.
Found my Problem. The calendar table that I imported was not defined as a Date Table. Once I did that all when well. Thank you for your assistance and patience.
STIBBS_807 Glad you got it working - that mark as date table is a hidden trick that catches a lot of people. I struggled with it for ages when I started learning Power BI and couldn't figure out why my calculations weren't working!