Calculate percent change between monthly and all time data

[Anonymous]

Hello all, could really use some help here. What I am trying to do is, by product, calculate the percent change between the percent of sales by month and the all-time percent of sales. Products are located in the items table and sales info is in the sales table, licked by item (multiple items fall into different product categories).

Here is what I can create right now:

What I'd like to compare it to is something like this. Where each product has its all-time percent of revenue, regardless of month: 

Then I would like to find the percent change. So for product one in January the calculation would be (22.65 - 18.85) / 18.85 = 20.1

Thanks!

[HashamNiaz]

Hi @Anonymous !

You can calculate the percentage contribution using below DAX;

% Contribution = 
    VAR _TotalYear = CALCULATE(Table[Contribution], ALLEXCEPT('Calendar', 'Calendar'[Date].[Year]))
RETURN
    DIVIDE( (Table[Contribution] - _TotalYear), _TotalYear)

It conside Table[Contribution] is a measure in your current model, where you are calcuating Average or Percentage for current month, use the measure and then calculate the Year Avergae or Percentage. Then finally divide it to get percentage contribution for each element.

Regards,

Hasham