Create a data set by extracting data from a table? - Part 2. Partial data. DataModel. DAX.

Originally Posted by CK76

Wait, on which workbook are you running your code?
You should only do it in your actual workbook. Not the sample I provided. As there were many broken links etc. I had cleaned those up.

Then you'll need to add named range to your workbook using the formula provided.

Then go into advanced editor and copy M codes there. Then paste it into blank query in your workbook.

Aha. That explains it!

Okay. I'll try that in an hour or so and see if I can pull it off. Will report back.

Best,

Elijah