Forum Discussion
% 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...
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.
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])
Let me know if anyone has any idea how to do it please