percent change formula helk

[bv27718n]

Hi! 

How do I do change a measure to get the percent change from PF life to PF life 2020, I have the actual variance but want the formula to be percent change. any help would be appreciated! 

[v-angzheng-msft · Accepted solution]

Hi, @bv27718n 

Create a measure like below, and format it as percentage

percent change =
VAR _var =
    SUM ( 'Table'[PF Life 2020] ) - SUM ( 'Table'[PF Life] )
RETURN
    DIVIDE ( _var, SUM ( 'Table'[PF Life] ) )

 result:

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@bv27718n ,

Based on what I got

divide( sum(Table[PF Life]) - sum(Table[PF life 2020]), sum(Table[PF Life 2020]))