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)...
  • TheoC's avatar
    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.