I am a huge fan of Unpivot (moving data from Column to Rows), but sometimes Pivot is your friend, when you need to move data from Rows to Columns. If you're getting this error "There were too many elements in the enumeration to complete the operation.
" trying to Pivot in Power BI, watch this video.
==========================
FREE Power BI Step-by-Step Tutorial http://www.learnpowerbi.com/bonus
👉 Download Lesson PBIX Files at http://www.learnpowerbi.com/bonus-dow...
✅ Subscribe to always get my latest videos: https://goo.gl/P79Hcr
👪 Join our Facebook Group / talkpowerbi
===Most Popular Playlists===
• Power BI Beginner Tutorial: https://goo.gl/KRRkPG
• Ultimate Calendar: https://goo.gl/pyki4K
• Power BI Data Modeling and more: https://goo.gl/WNtJFv
⚡Power On!⚡
-Avi Singh
http://www.LearnPowerBI.com
http://www.AviSing.com