Create a function to get data from the Data Model
We use a lots of queries within Excel.
Sometimes we need only one or two results after complex transformations (within the powerquery).
please create a function, maybe simular to the GetPivotData function or the lookup functions, but now to get data from the Data Model
Brian Coon commented
Cube value functions are too complex, they also don't work well with text columns.
Please give us the ability to use data model columns in VLOOKUP/XLOOKUP functions. That would be so nice!
The data model is really useful but all we can do with it right now is create pivot tables and charts. Adding this feature would allow Excel users to use the data in the data model in a customized way and without having to load all the data into a Excel sheet in the workbook.
Andrey Minakov commented
It would be great to be able to use DAX for that.
Mark Skilling commented
Have you tried using CUBEVALUE?