Potential video subject for you. There is a single video on TH-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!
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.
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.`
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
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.
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 :)
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
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 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?
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.
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 ❤❤
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
😄
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
Disclaimer: Highly addictive content
Once watched you cant get over this❤❤
Thanks Chandeep
As always lots of love to Goodly 💕
agree
You truly are a master! Thank you for sharing this very helpful piece of your knowledge.
This is EXACTLY what I needed! Thank you, you’re a lifesaver!
Potential video subject for you. There is a single video on TH-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!
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.
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.`
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.
This is so useful and clear explanation. Chandeep Sir, thank you so much! Subscribed.
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
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.
ghazab ki trik paaji! zabardast
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 :)
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! 😉
Another goody from Goodly! 😉 Thanks, Chandeep!
Brilliant! Thanks for the explanation!
Thank you for share this tricks!!!
Excellent solution, thanks Chandeep!
Very useful trick, Thanks Chandeep!!
another excellent teaching.
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 😀
Can you do a vedio on custom data types in power query and how can do merge and load those data types into excel?
Always fantastic 👍💯
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 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.
Thank you as always, great tip.
Great video, keep doing guy. 🎉
Thats awesome 👌
Hi Boss can you make a video of bulk replacement of values in power query
You are amazing!
That's great Video Bro.. ❤
Awesome ❤
insightful 👏👏👏
Great stuff
Love it!!
How to expand the list to show each record in a separate row? (not separated by comma in the same row)
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
Great video
very good .
what if i don't want to combine it but it want each on the list in different rows
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 ❤❤
th-cam.com/video/c8HQOCbJAzs/w-d-xo.htmlsi=bNaFjyIczOutCq-U
@@GoodlyChandeep Thanks for this, You are a life saver Man...
❤❤❤