Forum Discussion
Solved
Monthly Growth
Hi all,
I'm trying to display year-on-year growth for a dataset that has monthly data as below
My goal is to display the data like this:
Where the top chart is the monthly FYP for the current year, and the bottom chart is that number divided by FYP of the previous year. The problem is i can't figure out how to make the year dynamic. here is my growth formula for the bottom chart at present:
Growth New = divide(calculate('Dataset'[FYP1],filter('Dataset','Dataset'[Year]=2021))/calculate('Dataset'[FYP1],filter('Dataset','Dataset'[Year]=2020)),1)-1
Which is awkward and has to be changed every year. Is there a combination of formula and visual/page filter that will let me do this?
Thanks!
TODAY() will give you a date. YEAR(TODAY()) will give the current year. Is that what you want?
