Forum Discussion

bigdee008's avatar
bigdee008
Frequent Visitor
7 years ago
Solved

Unpivot Multiple Columns - Desktop

**total noob alert*    Is there a to unpivot multiple data in PBI desktop?    I have datasource = Excel which is has an unusable data structure. Table headers are shown transposed below: Im looki...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

I went ahead and took a stab at this. Here's the final output of what I did:

 

Not entirely sure if that is what you are looking for ( or maybe more of a step in the correct direction). If I understand you correctly, the next step would be renaming the Current Head with the New Header?

bigdee008's avatar
bigdee008
Frequent Visitor
7 years ago

Thanks a lot Nick and Greg, below screengrab shows the row 1 or my actual data set. Maybe that will shed more light on what im trying to accomplish. 

 

I came across the EXACT same thing im trying to accomplish here in the link, however, im not sure how to modify the query utilized there: 

 

 

 

 

    • bigdee008's avatar
      bigdee008
      Frequent Visitor
      7 years ago

      Hello v-cherch-msft Thanks for the effort but to say that I  understand what your are suggesting, i would be lying. Again i have to wwarn that I am a complete noob. Can you share a little bit more detail?