Power BI Practice Intro ROUND #5 I Pivoting in Power Query and what to do if it doesn't work

Looking for a challenge on data cleaning in Power BI? In Power BI Practice Intro Round 5 you need to pivot data, which will appear to be more difficult than that alone. So what to do if it doesn’t work? Requirements: - Connect to the csv file - Use Power Query to transform the data set so that you have the following columns: Order Number, Item Name, Quantity, Product Price, Order Date, Order Time - Show total sales on a horizontal bar chart in descending order Share your approach, questions, feedback below or on Twitter using the hashtag #PowerBIPractice and tag @HowToPowerBI Download file here https://datatraining.io/powerbi-how-to -------------------------------- 📊 TRAININGS 📊 --------------------------------- Power BI Design 4 Weeks Transformation Program https://my.datatraining.io/pages/powerbidesigntransformation Power BI Essentials https://datatraining.io/powerbilearningpath Business User Training https://datatraining.io/powerbi-business-users For Custom Trainings and Consulting email directly [email protected] --------------------------------- 😍 JOIN 😍 ---------------------------------- Join https://bit.ly/4b453bi Subscribe https://bit.ly/31MnQGO​ Insta https://www.instagram.com/howtopowerbi/ LinkedIn https://www.linkedin.com/in/basdohmen/ TikTok https://www.tiktok.com/@how.to.power.bi X https://twitter.com/HowToPowerBI fb https://www.facebook.com/groups/howtopowerbi Threads https://www.threads.net/@howtopowerbi Newsletter https://datatraining.io/newsletter --------------------------------- 👇 CHECK THIS OUT! 👇 --------------------------------- 💻 My gear https://amzn.to/47F21Yc 📚 Power BI books MUST READ! https://amzn.to/3tUfFcj 💡 General books I recommend https://amzn.to/48YNo33 🎶 Music for my videos https://www.epidemicsound.com/referral/8pjcbj 🚀 For growing on YouTube: https://www.tubebuddy.com/bas 🏄 Stuff I use daily https://amzn.to/3HqfMQ2 * Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos! Thanks for being a part of this channel and all your support! 💪 🙏 #HowToPowerBI​ #PowerBI​ #DataTraining​ #powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX