Monthly Growth

[jamiesonc]

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!

[HotChilli · Accepted solution]

TODAY() will give you a date.  YEAR(TODAY()) will give the current year.  Is that what you want?

[jamiesonc]

Thanks, i think the full question is too lengthy for a forum! this will work for now