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:

SKUSite 1Site 2Site 3Week
12310971
1239972
7891211
7892222

 

To create part of my report I figured it would be easiest if I could create a second data source from the original that is layed out differently, but I can't quite figure out if it is possible.

The end result would be:

SKUWeekSitePrice
1231Site 110
1231Site 29
1231Site 37
1232Site 19
1232Site 29
1232Site 37
7891Site 11
7891Site 22
7891Site 31
7892Site 12
7892Site 22
7892Site 32

 

Any Ideas?

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,

     

     

2 Replies

  • 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,