Calculated Column on Matrix

[estefaniamc]

Hi All, 

I would like to calculate the difference between two columns in a matrix (Volume version F09 and Volume version Plan/Actual Version"). I need to take into account that F09 can change and its going to be selected from a filter, so it can be F09, F10, F11 etc... Any tip on how to this?

Many thanks in advance, 

Regards

Estefania

[viethuynh]

I would like to know this as well.  Any solutions?

[Roseventura]

I would like to know this also, but instead of the difference, I need the Average.

Rose

[v-caliao-msft]

@estefaniamc,

Based on my research, there is no a easy to achieve this requirement, we need to create a measure to get the different between to columns. Here is a similar requirement with yours, please refer to the link below.
https://community.powerbi.com/t5/Desktop/Difference-between-2-columns-in-a-Matrix-Table/td-p/81614/p...

Regards,

Charlie Liao

[estefaniamc]

@many thanks@v-caliao-msft

But that doesn´t work for me.... 

Anyone can helP?