Create a derived table from a DAX query in PowerPivot?

Question

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.

score 2 · Accepted Answer · answered Jan 14 '16 at 08:43

2

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

answered Jan 14 '16 at 08:43

GregGalloway

11,355
3
16
47

Okay, I'm familiar with this workaround. Thank you for confirming it isn't directly supported. – Jason Jan 19 '16 at 16:09

score 1 · Answer 2 · answered Jan 13 '16 at 17:35

1

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.

answered Jan 13 '16 at 17:35

greggyb

3,728
1
11
32

Okay, that confirms what I've observed, myself. Thank you. – Jason Jan 19 '16 at 16:08

Create a derived table from a DAX query in PowerPivot?

2 Answers2