Forum Discussion
Transform data in Power Query
Dear all, I would like to ask your help on my issue. I have a data as attached with column "Value" contains 3 groups of data "Product", "Owner", "Size". Please your help to advise if it's possible ...
Dear Fowmy ,
I'd like to attached original data as below. The items under "Value" can be specified in 3 groups "Products", "Owners" and "Size". However, I can only define items under "Products" and "Size", the rest is belong to "Owners".
Kindly advise.
Thank you!
| Product | Size |
| Table | Small |
| Chair | Large |
Original data:
| Month | Week | Value |
| Jan | W1 | Table |
| Jan | W1 | Jack |
| Jan | W1 | Small |
| Jan | W1 | Chair |
| Jan | W1 | Joe |
| Jan | W1 | Large |
| Jan | W2 | Chair |
| Jan | W2 | Carol |
| Jan | W2 | Small |
| Feb | W5 | Table |
| Feb | W5 | Jessica |
| Feb | W5 | Large |
| Mar | W9 | Table |
| Mar | W9 | Marry |
| Mar | W9 | Small |
| Mar | W10 | Chair |
| Mar | W10 | Jack |
| Mar | W10 | Large |
Dear Fowmy ,
Thank you very much for your advice.
However, I am very new with Power BI, could you please help to clarify about this step? It is set by M language or select which tab in toolbars. And the meaning of this step.
Thanks a lot!
Hi Fowmy
Thank you very much for your support!.
I also have another question related to Power Query, please help to advise.
https://community.powerbi.com/t5/Power-Query/Transform-data-in-matrix/m-p/1294132