Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Matrix Visual: Subtracting two Columns

Hello,   Despite their being a few solutions I have seen to this same question, none seem to work for me. I simply want on new column giving me the data for 2021-2020, which is a simple varaince an...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Anonymous ,

    You could create a measure for each year separately to get the sum value and place them in the matrix as values. Then you could use these two measures to get the variance value and also place it as value in the matrix.

     

    2020 = SUMX(FILTER('Table','Table'[Year]=2020),'Table'[Value])

2021 = SUMX(FILTER('Table','Table'[Year]=2021),'Table'[Value])

Variance = [2021] - [2020]

     

    Example:

    Best Regards,

    Community Support Team _ Jing Zhang

    If this post helps, please consider Accept it as the solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi Anonymous ,

You could create a measure for each year separately to get the sum value and place them in the matrix as values. Then you could use these two measures to get the variance value and also place it as value in the matrix.

 

2020 = SUMX(FILTER('Table','Table'[Year]=2020),'Table'[Value])

2021 = SUMX(FILTER('Table','Table'[Year]=2021),'Table'[Value])

Variance = [2021] - [2020]

 

Example:

Best Regards,

Community Support Team _ Jing Zhang

If this post helps, please consider Accept it as the solution to help other members find it.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello Jing Zhang,

     

    Thank you very much!  For those of you who see this solution you have to enter the measures below seprately!

     

     
    2020 = SUMX(FILTER('2020 & 2021 FYS','2020 & 2021 FYS'[Year]=2020),'2020 & 2021 FYS'[Value])
    2021 = SUMX(FILTER('2020 & 2021 FYS','2020 & 2021 FYS'=2021),'2020 & 2021 FYS'[Value])
    Variance = [2021] - [2020]