Variation between two columns in a Matrix

[dmarangop]

Hi!

I created a Matrix with the sales information of 2020 and 2021, and I need to show in a third column the variation bewteen both years, like this, I dont know how to do this!, please help me

Category	2020	2021	%Variation
Deodorants	$254,885	$386,447
Footcare	$173,832	$272,357

Congrats,

Diana A

[negi007 · Accepted solution]

@dmarangop You can create a measure like below. and change the format to percentage

Option 1: If you have already have two measures for both 2020 and 2021

Variance = Sum(2021)/Sum(2020)-1

Option 2: if you do not have seperate measure

variance = (calcualte(sum(sales), year='2021') / calcualte(sum(sales), year='2021') ) -1 

let me know if it helps you