Before I start your video I am hitting liked button. Small request please share such dummy files for our practice. I m learning....GOOD LUCK one of your admirer & fan.
Great job. I need to study this in detail, but this use case of multiple column headers and row columns comes up a lot. You're solution is a really good one. Many thanks.
Hi Chandeep, can't thank you enough for sharing these business cases. They actually save the day for people like me. Looking forward to all of your videos that helps us in day to day issues.
I was stuck at this for a while not knowing what to do. Thanks bro, appreciate it. But one question. When I unpivoted my data, the blank cells on the value part of my dataset were gone. Is this a normal thing, did I make something wrong? PS: forgot to mention, I edited my data in Power Query Editor in Power BI
1 question, before loading data in power query, u have to convert turn data into table format, but if u turn data into table format, then would not be able to apply filter as per my requirement, and secondly, source who is handling/ preparing this data probably also may not be comfortable if he/she convert it into table format...
Thats awesome, but what if we have three headers?? In my case there is department name then attendance type, then total count of attendance hence 3 headings
Can you please confirm how was it added in power query? I didn't see you converting Excel data into table. Then how was this added to make it refreshable?
Sir,I am new to power bi(learning), could you please share sample exel file links in underneath your video,so that it is very helpful for me a lot to practice.....
Basically, I want every column to have non repetitive values except for 2 (which is usually the case with panel data, e.g. country and a range of years repeat). how would I do that?
Jas, I need to see the data to be able to let you know the solution. Can you share a snippet of the data and how do you want it transformed on my email - goodly.wordpress@gmail.com
@@GoodlyChandeep Wow thank you for the kind help. I actually took it from the power query and created a pivot table from it, and then set up the rows and columns as I liked so that got the job done. If you'd still like to view the data, it is: info.worldbank.org/governance/wgi/ It's the Excel file. Thank you for the out reach :) Your video really really helped me, I was so lost.
I can't seem to get it with this data: info.worldbank.org/governance/wgi/, I want countrycode, country, and year to be rows, and the values for all the variables to be columns. Could you help?
Check out our newly launched M Language course ↗ - goodly.co.in/learn-m-powerquery/
Before I start your video I am hitting liked button. Small request please share such dummy files for our practice. I m learning....GOOD LUCK one of your admirer & fan.
This has been a problem I have face for years and never known an easy fix, you have saved me hours and hours of work! Can’t thank you enough
Glad I could help!
Cheers
wow man you nailed it spot on. we just did for 3 headers. A big salute from Canada....!!!
I was struggling for days and then i came across your video. Thank you for this master piece.
Great job. I need to study this in detail, but this use case of multiple column headers and row columns comes up a lot. You're solution is a really good one. Many thanks.
I was just looking for this exact thing. Thanks bro! You're a legend!
Cheers!
Hi Chandeep, can't thank you enough for sharing these business cases. They actually save the day for people like me.
Looking forward to all of your videos that helps us in day to day issues.
Glad to hear that
So far the best tutorial on this topic!
Thank you for this master piece. You just saved the day.
I love your way of teaching.
Thank you!!
This is the first time I am commenting on a video. If I am complimenting this must be great video. Wishes 🎉🎉
This was easy to follow and helped me get my task accomplished! Thanks!
This is the one I have been looking for. Thanks
Perfect simplification!
Thank you so much!
As usual too good. Thanks Chandeep.
Brilliant once again.
U saved me a ton of time. Thanks bro
Super well explained 👌👍
Very well explained and helpful. Thank you!
Great example and easy to follow!
Glad it was helpful!
Super Thanks from me, a lot. Very helpful.
Thanks sir, this helped a lot!
Very Useful.. Thank you
Great vid thanks! What one can do if Seg 4 columns would be text?
I was stuck at this for a while not knowing what to do. Thanks bro, appreciate it. But one question.
When I unpivoted my data, the blank cells on the value part of my dataset were gone. Is this a normal thing, did I make something wrong?
PS: forgot to mention, I edited my data in Power Query Editor in Power BI
Thank you so much sir ☺️🙏
Thank you . Good one
U are my hero!!!!!
Big words.. thanks :)
Thanks a lot
Happy to help
Nice explanation sir...
1 question, before loading data in power query, u have to convert turn data into table format, but if u turn data into table format, then would not be able to apply filter as per my requirement, and secondly, source who is handling/ preparing this data probably also may not be comfortable if he/she convert it into table format...
thank you could you make a video of a more complex example...
Can you please share this data set?
Many thanks
Thats awesome, but what if we have three headers??
In my case there is department name then attendance type, then total count of attendance hence 3 headings
Thank you
Simply great
Ghazab!
Can you please confirm how was it added in power query? I didn't see you converting Excel data into table. Then how was this added to make it refreshable?
You can directly link the excel workbook into Power Query, that makes it refresh-able.
Creating a table is not necessary
Ok.. will try.. thanks
you are fxxx The Genius bro. you are the GOD
Thanks Bro!
Hi it is useful to me but i want to convert that final segment single row into multiple Rows as segmwnt 1 segment 2 can you suggest something
If we need the data like Excel without un piovet. Can we do like that.
As, I need to keep the 2 headers as excel
Sir,I am new to power bi(learning), could you please share sample exel file links in underneath your video,so that it is very helpful for me a lot to practice.....
super 👍
Basically, I want every column to have non repetitive values except for 2 (which is usually the case with panel data, e.g. country and a range of years repeat). how would I do that?
Jas, I need to see the data to be able to let you know the solution. Can you share a snippet of the data and how do you want it transformed on my email - goodly.wordpress@gmail.com
@@GoodlyChandeep Wow thank you for the kind help. I actually took it from the power query and created a pivot table from it, and then set up the rows and columns as I liked so that got the job done. If you'd still like to view the data, it is: info.worldbank.org/governance/wgi/
It's the Excel file. Thank you for the out reach :) Your video really really helped me, I was so lost.
Damn! Thank you!
How do you make month which really should be a column and not repeat hundred or thousands of time, so have Jan feb. march..... as unique columns ?
Is there a way to do this in google sheets?
th-cam.com/video/I3QabLHEuok/w-d-xo.html
Hi! How to do the opposite of this? PIVOTING multiple columns.
The goal is the first table seen in your video.
Can be done using a pivot table
I can't seem to get it with this data: info.worldbank.org/governance/wgi/, I want countrycode, country, and year to be rows, and the values for all the variables to be columns. Could you help?
how to do this in google sheets?
After I transpose the table, it says "Table is empty". Any way to solve this?
How to create cross tabulated data with multiple headers and columns using pandas in python.Thanks in advance
Best
Thank you!
👍
best
Thanks