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
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?