Power Query Custom Data Types Revolutionize Data in Cells

[excelisfun]

One of the coolest new features to allow us to have records in cells. So Rad!

[jimfitch]

Awesome feature! This will be especially useful in our manufacturing business where parts (unique part IDs) are central to & part attributes (e.g., description, unit of measure, commodity) are frequent derivative queries. For example, a work-in-process status report that lists open work orders, part numbers, quantities, dates, completion status, etc. A derivative query would be “what part is that?” or “what commodity?” or “unit cost?” To enable quick answers to such questions, we tend to construct wide tables (i.e., many columns) which make sizing (zoom) % navigation (scroll) more difficult. Custom Data Types will enable development of narrow tables consisting of only those columns needed for the report’s primary purpose (thereby making those reports less overwhelming, more readable, & more useful). If the report user needs to find other non-displayed part attributes, then simply click on the CDT icon to bring up the data card. Voilà, the attribute info is there! I hope this makes its way to GA soon, but I will try to temper my expectations after the long roll-out of LET. 🙂 As always, Mynda, a great tutorial. Your TdF example was a great illustration. Thanks!

[vijayarjunwadkar]

Mind blowing! I am super excited and can't wait to have this feature available generally! And as usual Mynda, you have delivered the knowledge in your best style, making it practical, precise and perfect! 😊👍

[sbatsia]

I follow your videos for quite some time, and I'm glad to take this opportunity to express my deep appreciation to your excellent training method and exceptional way of teaching.

[drsteele]

Good vid, Mynda. It's just terrific! I am one of the lucky ones for once, and I've been experimenting with this technology for a week or so. Mind-blowing.

[oliverbuckley]

Excellent video Mynda. Great demonstration of the feature as well as a great context in which to show it and how to integrate it into an application. Many layers of learning here. Well done and thanks again!

[phillipkadaoui]

Absolutely game changing stuff. This replaces about 80% of the formulas and stuff I use!

[timeckhardt]

Thank you Mynda for taking the time to demonstrate an application to the new feature! Another huge win for the MS team and I can only imagine it getting better in the months to come. I'll have my head buried in this for weeks after general release. Goodbye family time LOL!

[wayneedmondson]

Hi Mynda. Great stuff! Thanks for the preview. Can't wait for it to become widely available. Appreciate all your insights :)) Thumbs up!!

[kama]

Brilliant video once again! Thank you, Mynda. Just found out that I have that feature already and will start trying now - so exciting! Regards from Germany!

[felipe]

Mynda making or spreadsheet life every time easier! Love it!!!!

[johncon]

I had seen a couple of mentions for Custom Data Types but couldn't see how / why it may be of benefit. Thank you for the dynamic report and... throwing in the new formulas, xlookup, Array fill and valuetotext. Very helpful!

[zubairso]

This was really amazing, wasn't aware of this feature until now and now can't wait to try it.

[IlaPatel]

What a great new feature. Can't wait to start using it. Thanks for sharing!

[jueroe]

I lack the words out of admiration.... " I am delighted " Thank's again ! As you can see, you do not need to cycle and you belong to the TOP 50 ;-)

[julessarkissian]

Waow ! I usually use Excel for 5 years from now... And i never heard about this fantastique formula sort(filter())
You simply excel. I also think that you are one of the best in Excel advanced courses. I love you youtub channel.

[martinargimon]

HI Mynda. Excellent once again !!!! . Your knowledge of Excel is mind-blowing and you are an excellent teacher. Many thanks for all your tutorial videos, which are of great help to us all. Regards Martin (South Africa)

[Elbranto]

Great video - this could be very useful for me in the future. Thank you Mynda!

[Luciano_mp]

Wow. Awesome, very useful. Thank you Mynda!👍

[omarnader]

Thank you so much for your all efforts, appreciated