CODEWITHSUNDEEP
powerpivotdax
Jason
Jason

Reputation: 621

Create a derived table from a DAX query in PowerPivot?

Is it possible to create a derived table in PowerPivot from a DAX query? For example, the SUMMARIZE function returns a table. But, I haven't found a way to create a table based upon the value returned by this function.

Upvotes: 0

Views: 2786

Answers (2)

GregGalloway
GregGalloway

Reputation: 11625

If you have Excel 2013 it is possible though not as easy as the calculated tables @greggyb refers to. This article explains how: http://www.sqlbi.com/articles/linkback-tables-in-powerpivot-for-excel-2013

Upvotes: 2

greggyb
greggyb

Reputation: 3798

Currently the only product that allows calculated tables is Power BI Desktop. Power Pivot for Excel 2016 will likely get this in an update at some point. I can't speak to Power Pivot for previous versions of Excel.

Upvotes: 1

Related Questions