Forum Discussion

JACK__'s avatar
JACK__
Frequent Visitor
2 years ago
Solved

Create a new Data Source from an Existing Source

I currently have a data source like follows: SKU Site 1 Site 2 Site 3 Week 123 10 9 7 1 123 9 9 7 2 789 1 2 1 1 789 2 2 2 2   To create part of my report ...
Need Help
  • Arul's avatar
    Arul
    2 years ago

    JACK__ ,

    Go to Power Query Editor and select all the 3 site columns of the table you wanted to modify. Then, select unpivot columns (highlighted in the image),

     

     

    your resulted table should be like this, and then you can rename the value column as price,

     

     

Arul's avatar
Arul
Super User
2 years ago

JACK__ ,

Go to Power Query Editor and select all the 3 site columns of the table you wanted to modify. Then, select unpivot columns (highlighted in the image),

 

 

your resulted table should be like this, and then you can rename the value column as price,

 

 

  • JACK__'s avatar
    JACK__
    Frequent Visitor
    2 years ago

    Thank You 🙏