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?