Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 ...
Need Help
  • Fowmy's avatar
    Fowmy
    6 years ago

    Anonymous 

    I have attached the file with the transformation.

    You can download the file: HERE



     

    ________________________

    Did I answer your question? Mark this post as a solution, this will help others!.

    Click on the Thumbs-Up icon on the right if you like this reply 🙂

    YouTube, LinkedIn

     



Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
6 years ago

Anonymous 

Please share a table that specifies the items that come under Products, Owners and Size?

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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!

     

    ProductSize
    TableSmall
    ChairLarge

     

    Original data:

    MonthWeekValue
    JanW1Table
    JanW1Jack
    JanW1Small
    JanW1Chair
    JanW1Joe
    JanW1Large
    JanW2Chair
    JanW2Carol
    JanW2Small
    FebW5Table
    FebW5Jessica
    FebW5Large
    MarW9Table
    MarW9Marry
    MarW9Small
    MarW10Chair
    MarW10Jack
    MarW10Large

     

    • Fowmy's avatar
      Fowmy
      Icon for Super User rankSuper User
      6 years ago

      Anonymous 

      I have attached the file with the transformation.

      You can download the file: HERE



       

      ________________________

      Did I answer your question? Mark this post as a solution, this will help others!.

      Click on the Thumbs-Up icon on the right if you like this reply 🙂

      YouTube, LinkedIn

       



      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        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!