Measure to work out % of items sold year on year

[Anonymous]

Hi experts

I would you work out the percentage increase or decrease based on item and year for all products in dataset. This is just sample data.

Item         year       value

Apple       2020       5

Apple       2021       6

[Fowmy]

@Anonymous 

Please try the Measure given below.

% Change = 

VAR __ITEM = SELECTEDVALUE( Table8[Item] )
VAR __YEAR = SELECTEDVALUE(Table8[Year])- 1  
VAR __LASTYEAR = CALCULATE( SUM(Table8[Value]), Table8[Item] = __ITEM, Table8[Year] = __YEAR)
VAR __VARIANCE = SUM(Table8[Value])  - __LASTYEAR
VAR __CHANGE =  DIVIDE(   __VARIANCE,    __LASTYEAR)
RETURN
__CHANGE

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

Fowmy

Many thanks for the excellent feedback

[Fowmy · Accepted solution]

@Anonymous 

Thanks!

If it works for you, go ahead and Accept as a Solution 🙂

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn