Could someone kindly help me create a simple variance column in a matrix visualisation?

[Anonymous]

Hi all

I am quite new to Power BI - I have a matrix created from SAP data showing a P&L covering FY20, FY19 and FY20 Budget on the dashboard.

I am trying to create absolute var and % var columns for these , I thought I could add simple variance calculations - but it doesn't seem this straight forward compared to excel...

What is the best way of going about this? Should I create a measure - in which case how to I reference values in the matrix to make it dynamic. Or do I create a whole custom column? 

Couple of screen shots below of the data and matrix

https://imgur.com/a/MfmAwhd

Any help would be greatly appreciated

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may refer to the following posts.

• https://community.powerbi.com/t5/Desktop/Students-variations-year-over-year/m-p/345749#M155124
• https://community.powerbi.com/t5/Desktop/Percentange-Difference-on-selected-Years-only/m-p/589960#M279871