% evolution from the same column

[Avautier]

Hello everyone,

I would like to calculate an evolution rate from 2015 to 2016 but I don't know what to use (Calculate, date, Sameperiodlastyear).
And the last part but not the least, is that the 2016 date need to be dynamic. I was thinking about something like : YEAR(Today)

2016	37
2016	39
2016	46
2016	241
2015	-25,24
2015	-0,01
2015	1,55

Thank you very much forr your help.

AV

[v-sihou-msft · Accepted solution]

@Avautier

Can you show your entire dataset? And your growth rate is on date level or year level?

I assume you have date on each row. And you supposes to have a Year column in your table already. If you want to compare the total between current year on each row and Year 2015, then calculate the growth rate, you may create a measure like below:

=
 (
    CALCULATE ( SUM ( 'Table'[Value] ), ALLEXCEPT ( 'Table', 'Table'[Year] ) )
        - CALCULATE ( SUM ( 'Table'[Value] ), FILTER ( 'Table', 'Table'[Year] = 2015 ) )
)
    / CALCULATE ( SUM ( 'Table'[Value] ), FILTER ( 'Table', 'Table'[Year] = 2015 ) )

Regards,