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 ,

see my pbi file. I have splitted the column Week in 2 columns (week and year) in power query.

https://1drv.ms/u/s!Aj45jbu0mDVJi0DlD5sZpcgVxDjE?e=khhDbs

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hey Mangaus,

 

This looks promising. I will try it now. As I can see in the measure you created, you concatenated the columns to create a unique column. In that way, the calculations will be correct even if I have 1000 rows, right? 

Also, can you give me a solution for Week 1 and Week 52 issue? 

  • 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