Forum Discussion
Transforming data into new structure
Hello everybody,
now that I have failed several times, I want to ask for your support.
As a basis, I have shown several tables in the form of (1). I have a fixed number of 5 products at the moment with the corresponding numbers per month. The numbers per month are continuous, so they expand every month.
Now I want to translate the products from (1) into new product names by (2). Subsequently (3) is to be recorded, where all products from (4) are recorded and the monthly values of the same product names are now added up (Prod_AA = Prod_01 + Prod_02).
I hope I was able to describe the problem to you to some extent. I would be really happy for your help.
Kind regards 🙂
Anonymous
Do you want to create 3 as a visual or a table?
If it has to be a visual, follow Anonymous approach as below.
Define relationships as below.
4->2 (Prod_ID_NEW)
2->1(Prod_ID,Prod_id_old)
Create a visual from 4(prod_id_new),1(Month1,2,3 etc ->Summarize by SUM).
If you want to create 3 as a table, I would recommend to merge 1,2,4 in power query merge and do a GROUP BY prod_id_new.
If it helps, mark it as a solution
Kudos are nice too
3 Replies
Anonymous
Do you want to create 3 as a visual or a table?
If it has to be a visual, follow Anonymous approach as below.
Define relationships as below.
4->2 (Prod_ID_NEW)
2->1(Prod_ID,Prod_id_old)
Create a visual from 4(prod_id_new),1(Month1,2,3 etc ->Summarize by SUM).
If you want to create 3 as a table, I would recommend to merge 1,2,4 in power query merge and do a GROUP BY prod_id_new.
If it helps, mark it as a solution
Kudos are nice too