Forum Discussion

Oros's avatar
Oros
Post Prodigy
2 years ago
Solved

Subtract 2 Matrix table columns

Hello,

 

I have a calendar with fiscal year and in a matrix table.  How do you add a measure to have the third column as the difference between the amounts from the 2 fiscal years (22-23 and 23-24)?  Thanks.

 

(subtract per month between 2 fiscal years)

 

 

Need Help
  • TheoC's avatar
    TheoC
    2 years ago

    Oros  I think you will need to create a measure for each respective year (i.e. [Measure22-23], [Measure23-24] ) and then another subtraction measure which will be [Measure23-24] - [Measure22-23].  Then you will need to add the three measures to the Matrix visual.

3 Replies

  • TheoC's avatar
    TheoC
    Community Champion
    2 years ago

    Oros  I think you will need to create a measure for each respective year (i.e. [Measure22-23], [Measure23-24] ) and then another subtraction measure which will be [Measure23-24] - [Measure22-23].  Then you will need to add the three measures to the Matrix visual.