How to Lookup/ reference between Excel table and Power Pivot

NBA
NBA used Ask the Experts™
on
Hello,

Is it possible to perform, in Excel 2016, a Lookup from an Excel table (through Vlookup, other lookup/ reference functions, or its DAX equivalent Lookupvalue) into the data model (Power Pivot)?
My goal is to retrieve values from the data model into an Excel table.

The Excel table is composed of several thousands row. Each row needs to retrieve through Lookup/ reference functions a value from a table in the data model.
What would be the way to make this process the most efficient possible, from a time and resources perspective?

For example, is it possible to perform the lookup only when certain cell change?
What are the lookup and reference functions that are the most efficient?
If several hundreds of Lookups are to be performed simultaneously, how to optimize? VBA, existing tools?

Many thanks
NBA
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
NBA, If I understand correctly, you might benefit from a free download called DAX Studio as well as this video:
https://www.youtube.com/watch?v=dAYednIgJxM
The video's titled is "DAX Query to Export Data from Data Model to Excel Sheet"
At about minute 9, reference is made to the DAX "RELATED" command, which I think is akin to a regular VLOOKUP command in Excel.

DAX Studio is available from http://daxstudio.org
NBA

Author

Commented:
Hi Paul,

Thanks a lot for your answer.
It actually solved more than one question I had :-)

NBA

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial