Calculate the difference between calculated values in matrix visual

[smithshire]

I have a matrix visual which displays a calculated measure of the total spend for each customer for the selected months.

The month names are derived from a calendar table.

I need to add an additional column to show the spend difference

Customer	February	March
Test Customer 1	£1,838.84	£1,396.22
Test Customer 2	£2,258.71	£1,104.65
Test Customer 3	£5,273.80	£5,811.98
Test Customer 4	£1,506.00	£1,702.00

With difference :-

Customer	February	March	Difference
Test Customer 1	£1,838.84	£1,396.22	-£442.62
Test Customer 2	£2,258.71	£1,104.65	-£1,154.06
Test Customer 3	£5,273.80	£5,811.98	£538.18
Test Customer 4	£1,506.00	£1,702.00	£196.00

What would the best way to achieve this?

Thanks

[smithshire]

's great - thanks.

[amitchandak · Accepted solution]

@smithshire , these are measure then we create measure like

This moth Vs last month

MTD = CALCULATE(AverageX(values('Date'[Date]), calculate(SUM(Table[Qunatity Produced])) ),DATESMTD('Date'[Date]))

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))

And we can take diff

Select Two period and take diff

How to use two Date/Period slicers

https://youtu.be/WSeZr_-MiTg