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

     



orlandom's avatar
orlandom
Icon for Advocate I rankAdvocate I
6 years ago

Hi Anonymous ,

If you're new to Power BI there's an alternative you could try in the August 2020 version of Power BI Desktop. The feature is called Text from Examples.

The steps are as follows:

Enable the Text from Examples feature in Power BI
1) Download/Update Power BI Desktop to the August 2020 version
2) Open Power BI Desktop -> Go to File -> Options & Settings -> Options -> Preview Features -> Mark on Import Text Using Examples -> Click OK
3) Close and open Power BI Desktop

Import the data

1) Save the data as a text or csv.
2) Go to Home -> Get Data -> Text/CSV and browse for the file
3) On the bottom-left corner -> click on Extract Table Using Examples

4) Then type the expected column names and enter a few examples until Power BI gets the full pattern. Notice that depending on the complexity of the data you'll need to enter more examples. In the picture below, the values in black were entered by me and the ones in gray were extracted by Power BI.

 

Hopefully your dataset is bigger than the example provided so you'll take advantage of the automation.

Hope this helps!
Orlando Mezquita
www.MasterDataAnalysis.com

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi orlandom ,

     

    Thanks for your advice.

    Actually, my data is complicated than example so I may not apply it in this case, but it's great techniques.