Subtract 2 Matrix table columns

[Oros]

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)

[TheoC · Accepted solution]

@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.

[Oros]

@TheoC ,

Thanks!

[TheoC]

Pleasure @Oros 

All the best! 🙂