How to create a percentage change measure in Matrix table

[JayKarim]

Hi Power BI community 🙂 

I have a matrix table with 3 columns

1. Product
2. (Total Sales £) YOA 2020
3. (Total Sales £) YOA 2021 

What I would like to do is add a third column with % varaince between column 2 & 3

Would someone mind explaining have a I can do this why an expression?

Many thanks in advance

[JayKarim]

Hi Samarth, 

This worked 🙂 Thank you so much

Jay 

[Samarth_18 · Accepted solution]

HI @JayKarim ,

You can try below code:-

variance =
VAR result =
    DIVIDE (
        ( [Total Sales £) YOA 2021] - [(Total Sales £) YOA 2020] ),
        [(Total Sales £) YOA 2020]
    )
RETURN
    FORMAT ( result, "PERCENTAGE" )

Note- I am considering you have created a measure for the calculation of (Total Sales £) YOA 2020,(Total Sales £) YOA 2021 

Thanks,

Samarth