Sometimes your data isn’t shaped the right way. Have you tried the Pivot or Unpivot methods in Power Query? They can help get your data looking the right way for your Power BI reports!

Pivot columns
https://docs.microsoft.com/en-us/power-query/pivot-columns

Unpivot columns
<a href="https://docs.microsoft.com/en-us/power-query/unpivot-column" target=”_blank” rel=”nofollow”>https://docs.microsoft.com/en-us/power-query/unpivot-column

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #PowerQuery #GuyInACube