Forum Discussion
Calculated Column on Matrix
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
4 Replies
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/page/2Regards,
Charlie Liao
I would like to know this as well. Any solutions?
I would like to know this also, but instead of the difference, I need the Average.
Rose
