How and why to Unpivot data with Power Query 

This is great! No surprise as you explain everything very clear and easy to follow. Thank you very much

Excellent video, thanks so much! I did a Power BI course 2 weeks ago, feel like I've already forgotten nearly everything, plus the data I'm working with is a lot more complex than what we used in the training. Your clear concise video is a lifesaver.

Apart from being very informative and clear, your voice and accent make it super enjoyable. Thanks!

You absolutely nailed it, one of the best overall videos about PowerQuery! I like your articulation and the instructions are sophisticated, yet easy to follow. Great content!

Breakthrough! I have been trying to understand pivoting all afternoon! Your video has nailed it

This is the powerhouse of knowledge. Amazing work. Thank you!

Unpivot is an amazing tool. I like how you’re like “it’s beautiful” because it truly is. Especially the unpivot other columns which gives your source data the ability to expand in columns without messing up your query.

Good lesson, from basic to more complex solution. Thank you! 👏

Super helpful, thank you. Very clear, concise, well-explained, and a new user I appreciate the little side tips and best practice notes thrown in as you went through the steps.

I had a thorny data problem with some credit card file downloads where I needed different information for different purposes: sales sheet tie out, bank tie out (each neededing horizontal layout with different data filtered) and journal entry (needing no filtering but some cajoling and a vertical layout for entry upload). The unpivot was key. This technique needs to be in everyone's toolkit. As always your explanations are clear and highlights the benefits (and ease) of the technique.

Great tutorial. Thanks so much.

Excellent tutorial, thank you Wyn!

Thanks Wyn, excellent lesson.

Mind blowing!!!! Brilliant way to break data into rows!!!!❤️🔥❤️🔥

Awesome explanation, so helpful! Thank you!

Great Explaination! Thank you so much.

Good one

Thank you so much! Great explanation!

I live that you add the tbl at the start of the table name. Methinks you have a programming background. I do that, too. At first glance, it is seems unnecessary but in complicated vba code it makes perfect sense.

Tis tutorial is very nice. I have learnt the easy way. If gave the source file , it would be easy to practice.

Excellent video , thanks for sharing your knowledge

❤❤❤ Thank you so so much. I’m having do many emotions right now.

More videos please, you're the best

Very nice, thank you.

Great !!1 God bless you.

Your tutorials are very useful and straight forward. I just wish you added links to download the tables you are using in your videos so one could practice while watching :)

Great tutor!

Thank you very much sir.

Great! thanks

I’m enjoying your videos so much and happy to keep learning. Thanks for creating great content!🙏 I’m curious to know why use a separate date table as a reference table. Is it essential, or can one go without it? Additionally, for those without Power BI access, is there a way to achieve this in Power Query?

The tutorial is nice. Calling tidy data in pivot horrible is just 🤣🤣🤣 Tidy data and unpivot data are both perfectly fine, it only depends on what you need it for.

Thank you

7:52 How do you do that? I know how to merge queries with common fields, but splitting a table? The best approach which I can think of is: 1) Duplicate the query; 2) In each respective query, delete the columns which are unneeded. Then you will have two (2) tables, each with the respective columns you need.

Thanks Sir 🙏

Thanks Wyn， excellent video 👍. Just a small query, around 12:29 in the clip, you said that 3 fact tables. I am not sure but feel they are dimension table. Myabe slip of the tongue? Just curious。 Thanks

SUPEEER

best

Great Wyn! The second example was tricky! Thanks for walking through the process. Just curious, I noticed in your Fields list that the My Measures table shows at the top of the list. My field list sorts automatically alphabetically. So, I must name my measures table as something like --myMeasures or 1-myMeasures for it to sort to the top. How did you position yours at the top before the Auditor Table and Calendar table, etc. that would all naturally sort before the M of MyMeaures? I rooted around for a setting and couldn't find one. Curious how you do that. Thanks again for all the tips. Thumbs up!!

great video. btw, where are the downloadable files?

Hi Thanks for the video. I have 3 columns of values and at the very before the column header it is written the date in which identifies the value in the column belongs to a certain date something like this: 202201|202202|202203 how can I fix this issue in power Q to read in Power BI? will it make sense to create 3 different columns of dates relative to the date of the column and then povit them and then povit the 3 columns also? im kindda confuse. your help would be great :)

Do we have to create tables for all dimensions? What if we have many dimensions?

Sir, How can I revert the unpivot excel value. Please it would help me a lot.

7:09 What about SUMIFS distinct values?

unfortunately one Episode from 4 have workbook to practice 😔

Please get back to me ..I would like to pay for a private class