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