Excel 2024: Create Your Own Data Types
July 24, 2024 - by Bill Jelen
![Excel 2024: Create Your Own Data Types Excel 2024: Create Your Own Data Types](/img/excel-tips/2024/07/excel-2024-create-your-own-data-types.jpg)
Data types sound great, but wouldn't you like to have your own company data as a data type? Imagine if you had your company product list in a data type. You could store the SKU in a column and then extract item information using XLOOKUP
or dot formulas such as =A2.Country
.
There have been three solutions from Microsoft that allow you to do this. Power Query was first. Then Power BI. Then a Javascript API. I've tried them all. I want these to work just like real data types do. Here is my wish list and how PQ (Power Query), PBI (Power BI), and API (JavaScript API).
![](/img/content/2024/07/BS22-112.png)
So far, the best experience is JavaScript API. Here are three videos, one for each method.
Power Query |
Power BI |
JavaScript API |
![](/img/content/2024/07/1.png)
![](/img/content/2024/07/2.png)
![](/img/content/2024/07/BS22-113.png)
This article is an excerpt from MrExcel 2024 Igniting Excel
Title photo by Kelly Sikkema on Unsplash