For Excel for Windows users, the Data Model is the recommended place to store data in Excel, especially when you’re working with multiple tables or large tables.

Most people use the data in the Data Model to create Pivot Tables. However, there’s more to the Data Model than acting as a source for Pivot Tables

In this video I show you how to use a combination of DAX Measures and Excel’s CUBEVALUE function to take a value from the Data Model and display it in a cell in a worksheet.


Creating a Measure

Create the CUBEVALUE Function

Add a Formula to the TextBox