Creating a Custom Data Type with Power Query; including XLOOKUP and Dynamic Arrays

/in /by

The new Custom Data Types are starting to be rolled out and they’re … exciting … interesting … spooky.

This video will be the first of several that will explore the Custom Data Types, how they can be used and where to watch for GOTCHAs.

In this video we create a basic Custom Data Type using information about specialists. We have their names, contact info, specialties, birthday and school data. Later we add in their hourly rates by using XLOOKUP.

#XLOOKUP
#CustomDataTypes
#PowerQuery

You also see the FILTER function for Dynamic Arrays. GOOD STUFF! 🎉

For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2