Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Variance column in matrix

Hi,   How can I create a third column in a matrix to show variance YOY, without creating individual measures for reach value of Revenue, Costs, Profit, etc.?     2018 2019 third column for ...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

= divide(sum(2019)-sum(2018),sum(2018))

or

measure =

var _a =sum(2019)-sum(2018)

return

divide(_a,sum(2018))

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi amitchandak 

     

    Thanks for the quick reply.

     

    I'm not sure how I can do "sum(2019)"?

     

    Cheers,

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      Please share your table structure

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        amitchandak ,

         

        See below screenshot... will this work?  or how else can I share my table structure?

         

        I think one of the obstacles here is that each of the rows in the matrix come from different columns in the data table... which means the DAX formula for the variance cannot reference a specific column, but needs to reference the row it is on.

         

        Cheers,

        Dan