Forum Discussion
Calculation
Guys, good morning! I have a sales table with two years being 2020 and 2021, I need to do the following calculations 2021 product sales amount * 2021 product sales amount 2020 product sales amount * ...
Okay, I'll try to make a logical explanation and I'm attaching an example of how I did it in excel
1° Step
2020 product sale value * Number of products sold - 2021
2° Step
2021 product sale value * Number of products sold - 2021
3° Add the total of products after the multiplication ( Separated by year, each year has its sum)
4°
Divide the sum of 2021 by the sum of 2020 - 1
I can only consider products that are in both years,
The value I need is the one in yellow:
Try DIVEDE function:
Measure = DIVIDE(SUM('Table'[2021 sales]),SUM('Table'[2020 sales]))-1If you provide aggregated data, it is difficult to know your data model. Please provide the original data model in pbix with virtual data.