I’ve built my CAGR (compound annual growth) dax formula based on Curbal’s video https://www.youtube.com/watch?v=jIb--ImdjNg
I have the calculation working on a small dataset where all amounts are nicely summarised into years.
File is here https://www.dropbox.com/s/50miu8jli5xd6yt/CAGR.pbix?dl=0
Then I’ve tried to apply the same formula to a larger dataset where sales data is by day.
CAGR is showing as “1” which is incorrect as it should be the “sales var to LY %” of this year + all other years preceding.
File is here: https://www.dropbox.com/s/v3w9jdak56zngyy/Mock%20Data%20PBI.pbix?dl=0
What am I doing wrong?
Many thanks,
Tim