Forum Discussion

fletchuk's avatar
fletchuk
Regular Visitor
7 years ago
Solved

Trying to create a difference column in a matrix table

Hi,   I have a matrix table which shows the sales for products this year and last year. All I want to do is add a column which shows the difference between these two columns. I've been trying all a...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    fletchuk,

     

    Make sure it is a measure, not calculated column.

fletchuk's avatar
fletchuk
Regular Visitor
7 years ago

By the way, this is the code i'm using to create the difference column:

 

Difference = CALCULATE ( SUM ( Sheet1[Sales] ), Sheet1[Year] = "TY" )
    - CALCULATE ( SUM ( Sheet1[Sales] ), Sheet1[Year] = "LY" )

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    7 years ago

    fletchuk,

     

    Make sure it is a measure, not calculated column.