Year over Year growth with multiple years

[AdiKujan]

Hi guys,

I have a table with multiple rows, "years" as columns, and "revenue" as value. What I want is to create a measure which calculates the following:

Revenue (year in column)  / Revenue (Year in previous column)


This way i get a year to year revenue growth.  

I can only manage to find a way to create a measure which creates the value of the previous year, but not the growth of the previous year compared to that previous year.

For example I need the measure to calculate  2019/2018, but also 2018/2017, and 2017/2016.

Quick measures wont work.

[v-frfei-msft]

Hi @AdiKujan,

Could you please share your sample data and excepted result to me, if you don't have confidential data? Please upload your file to One Drive and share the link here.

Regards,

Frank

[AdiKujan · Accepted solution]

Hi @v-frfei-msft,

I can post a screenshot of the table how I got him after using my solution.

Hopefully this will help someone else in the future.

Kind regards,
Adi

[AdiKujan]

YoY =

IF(   YEAR(   LASTDATE(   'Date Table'[Date]   )   )  =  2017;

      BLANK()

            ;IF(YEAR(LASTDATE('Date Table'[Date]))=2018;

                  SUM(Revenue Table[Revenue]) / CALCULATE(SUM(Revenue Table[Revenue]) ;'Date Table'[Year]=2017 ;                   ALL('Date Table'))

                        ;IF(YEAR(LASTDATE('Date Table'[Date]))=2019;

                                 SUM(Revenue Table[Revenue]) / CALCULATE(SUM(Revenue Table[Revenue]) ;'Date  Table'[Year] =2018
                                 ;ALL('Date Table'))
                        )
             )
)