Create a derived table from a DAX query in PowerPivot?

0
votes

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.

2
powerpivotdax

2 Answers

2
votes

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

1
votes

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.