Dealing with DOUBLE HEADERS in Power BI using UNPIVOT, TRANSPOSE, and FILL DOWN

Learn how to restructure data sets that have double headers in Power BI. See how to do it using unpivot, transpose, and fill down. Enjoy!

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
😍 JOIN 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* 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

[rewinwilson]

Can I just say "Thank you"... You've covered all the scenarios that are usually made up in the corporate world of "Table making".... Thank you much... Very informative and detailed....

[leewarps]

Exactly what I was looking for, and even more! Thanks brother, will check out your other videos as well.

[EricaDyson]

And just what I needed also! Great explanation... step by step.. and really practical. Thanks a bundle.

[rokaskrisciunas]

Dan Bilzerian of Power BI. Thanks! Great material

[andysmudge]

Wow!! I never knew these features or I can say, I have never explored them. Kudos brother. That's so helpful. 😊

[hotookhatri]

I was facing problem, because of three headers. last part of the video helped a lot, thanks you for positing it is very helpful.

[carlavernooy]

Thank you so much!! Just what I was looking for.

[anthonyalessi]

This is an amazing tutorial! One problem I've noticed is when transposing if the query has a lot of rows it runs out of memory to perform the action. Hopefully row-wise functions come at some point. Thank you for posting this, really helped me understand pivot better!

[cahardikpishavadiya]

Hi Das, thank you so-so much, this has been very helpful.

[pankajkumarit]

Super Cool Trick to resolve the Double Headers... WOW

[totvabe]

Step by step, with these explanations everything seems to be easy.

[barttitulaerexcelbart]

Very good explained. Thank you. Good that you increase the level of complexity. One remark: I did use your example in Excel, then comes an extra step, because in the region row, I have not null but Column2, column3 etc.

[shimaagomaa]

You are AMAZING <3 Thank you so much

[narminhumbatli]

it helped me more than everything with dirty unstructured data

[milagrosjaraquispe]

It's an amazing tutorial! easy to undestand :)

[balrajsanthosh]

I'm speechless with the way of explanation for the conecpt, its more than awesome bro 😍❤

[shravanrao]

Thank you so much brother! This was absolutely important for me to impress my boss😁😁

[kishoredubbasi]

Hey Great thanks! But I have scenario where I have to show calculated measures which is not visible in power query how to fix this it will be a great help thanks in advance!!!

[jitendratrivedi]

Very useful tips. Please post more videos on power query/data cleansing/transformation.

[maheshbabu]

Could you please let me know how to do if my values are measures