Forum Discussion
mihaipaculea
5 years agoNew Member
Remodeling the data from columns to rows based on timestamp/date
Hi everyone, I am an medium expierienced user of Excel but quite new to PowerBi. I am trying to solve a problem which I suppose will require remodeling the data but I am completly lost and sear...
- 5 years ago
mihaipaculea , unpivot the data
https://radacad.com/pivot-and-unpivot-with-power-bi
Video: https://www.youtube.com/watch?v=2HjkBtxSM0g
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/ - 5 years ago
Hi mihaipaculea ,
Go to query editor>select all the tag columns>unpivot columns:
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
v-kelly-msft
Community Support
5 years agoHi mihaipaculea ,
Go to query editor>select all the tag columns>unpivot columns:
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!