Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

% Difference from previous week

Hi all,   I have columns, country, customer, product_group, model_id, week, year, price, and sales (#). I have several countries, and each country has several product_groups, and each product_group...
Need Help
mangaus1111's avatar
mangaus1111
Solution Sage
3 years ago

Hi Anonymous ,

I have splitted the column [report_date_week] in 2 columns, I have not done any concatenation.

Try if it works in your model.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

It worked the way you did, but for the % to work, I have to have all the columns in the table, which is fine. But some tables will only have year and week, for example. And I will be looking for Avg. Price, for example. 

I tried to work on your script but couldn't manage 😕 Can you help?

 

I created Avg. Price measure as follows; 

Avg. Price = AVERAGE(Sheet1[Consumer Price])

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Let me know if anyone has any idea how to do it please