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 Greg_Deckler . I can share the file but Im not sure how to do that on this forum.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

If you have confirmed your email address, you can attach to a post. Otherwise, most people just use One Drive, Box, etc.

  • bigdee008's avatar
    bigdee008
    Frequent Visitor
    7 years ago

    Thanks a lot v-cherch-msft I attempted changing the source in the file you shared, however, I am ending up with an error in the Advanced Query Editory everytime. As bizzare as this may sound, i spent the entire day on this yesterday.

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    Hi bigdee008

     

    You may paste the applied steps to your actual data in query editor.

     

    Regards,

    Cherie