Power BI Practice Solution 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 Round 5 we have an in-depth look on pivoting data in power query and 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 datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly [e-mail]
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO​
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on CZcams: www.tubebuddy.com/bas
🏄 Stuff I use daily 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

[@florincopaci6821]

Thank you so much for sharing the solution!

[@HowtoPowerBI]

😀hope you like it

[@sandeepreddy7687]

Great video, Bas. I was not aware of these techniques earlier. Hope to see few more challenges.

[@HowtoPowerBI]

thank you, really nice to hear you picked up some new stuff from it!

[@laiqmehdi8704]

we need more of this kind please i request you to start it again

[@paolaggl]

thank you so much for your videos! ive learnt a lot! However i tried with the third method and then i wanted to change the date with the first approach you showed and didn't work :( could you help me?

[@spen2431]

Excellent and thanks for showing 3 different approaches. Not sure why you would do anything other than the first one though :)

[@HowtoPowerBI]

haha it is definitely the easiest option! It helps though to understand what it generates so you can tweak it if necessary

[@metecakmak376]

What would be the reason for getting the error about my file path? I'm currently based on Turkey do you think my regional settings can be a reason for this?

[@vigneshkumar8720]

Try removing double quotes in the source path and try again

[@abubakrsaadmakyhoun7535]

I liked second method

[@HowtoPowerBI]

that was the approach I initially took. The first option generates a query thats quite similar though. Third option runs the fastest.