How to Fix Pivoting Errors in Power Query
Вставка
- Опубліковано 15 жов 2024
- Check out our newly launched M Language course ↗️ - goodly.co.in/l...
Are you facing errors while applying pivoting to your data in Power Query? In this video, I will discuss the common causes of these errors and show you how to fix them easily.
#powerquery #dataanalysis #datacleaning #datatransformation #PivotColumn
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/l...
✔️ Power Query Course-
goodly.co.in/l...
✔️ Master Excel Step by Step-
goodly.co.in/l...
✔️ Business Intelligence Dashboards-
goodly.co.in/l...
===== LINKS 🔗 =====
Blog 📰 - goodly.co.in/h...
Corporate Training 👨🏫 - www.goodly.co....
Need my help on a Project 💻- www.goodly.co....
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!
Check out the M Language course ↗ - goodly.co.in/learn-m-powerquery/
You are one tricky bugger!! I absolutely love the way your mind works!!
I felt baaad. I'd like to be called a de-bugger
😄
This is EXACTLY what I needed! Thank you, you’re a lifesaver!
Disclaimer: Highly addictive content
Once watched you cant get over this❤❤
Thanks Chandeep
As always lots of love to Goodly 💕
agree
Well, that explains some of the errors I was getting and couldn’t figure out why! Very helpful video-Thank you!!
Best explanation about pivoting I stumbled across. Thanks for the video
Potential video subject for you. There is a single video on UA-cam with no talking, just background music on a workaround for regex in Power Query. I think a lot of people would want to see such a video from you. Enjoy your content and have learned from your videos. Thank you.
This is great! I've used an index column in the previous step. Each row has an unique number. Split (duplicated) the query, pivoted one query and merged them afterwards. I got the same error behore I came up with my solution, but now I know how to do it better!
You truly are a master! Thank you for sharing this very helpful piece of your knowledge.
Hai Goodly ,
I have an issue
In power query editor date column is in format dd-mm-yyyy
But I created in the format of yyyy-mm-dd
Using
Text.From(Date.Year([loaddate])) & "-" & Text.From(Date.Month([loaddate])) & "-" & Text.From(Date.Day([loaddate]))
The output is come in yyyy-mm-dd
But I am trying to convert into date data type
This custom column values also changing into dd-mm-yyyy
What should I do now ...
I tried many ways ...
Kindly help
I need in yyyy-mm-dd only
I am a fan of your videos. Have you come across the error below when Pivoting. It only happens in the Power BI Service, the Power BI Desktop works normal. Very odd.
`Expression.Error: We cannot convert the value "[List]" to type Table.. Value = [List]. . The exception was raised by the IDbCommand interface. Table: Tickets.`
I have no words to thank you enough. This really has just saved my day. Exactly what I needed!
This is absolutely my favorite channel for learning how to use Power BI!
Can we make a nice org chart on Power BI with the native visuals or with any custom visuals when our data feed consists of 4-5 levels with 40+ employees. If there is a way to build a proper org chat, could you please do a video on that. I've been searching for this since few weeks didn't find any useful information.
Thanks for your video. What if instead of combining the text value, I would like to create new rows? For instance in your example, I want Comm and PBI to be in two separate rows? Thank you.
Now I would like to see a video regarding how to handle errors when UNPIVOTING! Thanks.
Give me an example
goodly.wordpress@gmail.com
@GoodlyChandeep Ah, I was just curious!
Maybe it isn't as much of a problem to unpivot! 😉
This is so useful and clear explanation. Chandeep Sir, thank you so much! Subscribed.
Thank you for share this tricks!!!
Thank you very much, i was looking for it :) I rather prefere to automaticly create additional columns if use separator in one cell. But at list someone explain how to fix this error. Thank you again :)
Another goody from Goodly! 😉 Thanks, Chandeep!
Brilliant! Thanks for the explanation!
Very useful trick, Thanks Chandeep!!
This video made me feel more at ease with power query formula. How did you vet so good at this? Do you have previous programming experience? How did you decide to make M your niche? Best,T
Luck by chance 😀
Excellent solution, thanks Chandeep!
another excellent teaching.
ghazab ki trik paaji! zabardast
Thank you Chandeep for the video! when we deal with millions of rows and the errors are far a way from the first 1000 records it become very difficult to find the columns that contain errors. Could you help me to find out how to solve this type of problems?
do not apply pivoting when working with millions of rows. pivoting may drastically slow down your query.
you'll need to build an error checking mechanism. unfortunately I don't know of a way to visually identify errors beyond 1000 rows
@@GoodlyChandeep Thank you Chandeep for your feedback!
@@GoodlyChandeep my question is not specifically related to the pivoting.
Can you do a vedio on custom data types in power query and how can do merge and load those data types into excel?
Could you please make a video on How to sync slicers across reports ?? Currently this feature isn't available in power hi although Cross report drillthrough is available , but I assume there must be some ways to achieve this??
Thank you as always, great tip.
Great video, keep doing guy. 🎉
insightful 👏👏👏
Always fantastic 👍💯
Hi Boss can you make a video of bulk replacement of values in power query
Great stuff
You are amazing!
Hey chandeep great solution but want to know when the pivoted column consists both text and numbers the text.combine function gives error for numeric values. Even number. To text doesn't work as well any solution is much appreciated.
Use Text.From
That's great Video Bro.. ❤
Thats awesome 👌
4:37 How do we know that adding the “each _” is going to give a list? Thanks.
Each _ is a short hand for writing a function and the last argument was a function.
very good .
Awesome ❤
Love it!!
Great video
How to expand the list to show each record in a separate row? (not separated by comma in the same row)
Sir I have more Queries ,can u help me plj
Hi there, I love the way you teach us, i have a doubt if you or someone can help me out
I need to consolidate approx 45 sheets on a daily basis. The catch is my headers in every sheet starts from A8 to S8 and and from A1 to A6 there's some rubbish data(i need to igorne this except for A3)
A3 has a location name. This location goes in column T, every workbook has a different location name.
The output should be like this
A8 to s8 headers should be in A1 to S1 and new column should be added for location in T.
If there are 500 rows in workbook 1, then the location name for 500 rows should be same i.e from A3(workbook1)
2nd workbook having 200 rows then in consolidated file, the next 200 rows should have loc name from 2nd workbook(a3)
Can someone help me out creating a power query for this.
Thanks and Merry Christmas ❤❤
ua-cam.com/video/c8HQOCbJAzs/v-deo.htmlsi=bNaFjyIczOutCq-U
@@GoodlyChandeep Thanks for this, You are a life saver Man...
❤❤❤