Forum Discussion
Solved
Variation between two columns in a Matrix
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 ...
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
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