Create a Calculated Column in a matrix

I am not really sure if there is an easier way. I have two date tables which I use as slicers allowing me to select two periods to compare and then I have a master date table where I create my calculations, e.g. sales for period 1 and sales for period 2

Hope this makes sense and apologies if I have misunderstood what you are trying to do.

Edit: I have attached a screenshot of how my matrix looks if that helps.

Shona

Hi Shona

Thanks for that :smileyhappy:

I  have managed to do it by creating a seperate date table then by creating a previous year measure and % change measure. When I now select my required month by way of a filter it will show this month for the current year and the previous year coloum will filter to show the sales for that period last year and the % variance between these two months.

Thanks for your help...