Create DAX calculated measures in Excel for SSAS Tabular
Enable writing measures in DAX in a pivot table connected to Tabular or Power Pivot.
In practice, it would be enough to enable a choice between MDX and DAX in the "New Calculated Measure" dialog box and use the following syntax for creating a DAX measure instead of an MDX member in measures…
CREATE SESSION MEASURE [Model].Sales[My Sales 2] = SUMX ( Sales, Sales[Quantity] * Sales[Unit Price] /5 )
I received this requests from several enterprise customers, but I think it's useful to any data analyst accessing tabular models (but you should be able to write DAX measures also for SSAS Multidimensional, why not?)
Thanks for logging this one, Marco, and for encouraging the community to vote.
I’m adding this to the list of Pivot table enhancements… more votes will boost the priority of getting it in the product, thanks!
This would be really helpful for clients who rely on Excel data from Tabular Models. It works in Power BI now we need it to work in Excel.
Clifford Dibble commented
I create many Excel workbooks based on the same Power Pivot data sets. These are rather complex exploratory analyses, so I can't easily put them into the same workbook, because it would very large and hard for consumers to navigate. Each time I create a new workbook, I find myself having to recreate the same set of measures over again. I'm really getting tired of this.
I want a DAX data definition language (DDL) and a scripting ability so that I can simply import the measures by executing the DAX DDL script. I looked at DAX Studio and the DEFINE/EVALUATE verbs, but there doesn't seem to provide a way to do this. I ended up in the weeds with OLE DB providers and XMLA scripts, and ADOMD - none of which seem to apply to Excel.
I think this must be a common use case for those of us who still prefer the Excel environment for exploratory analysis. In the meantime. I'm happy to cobble things together in C# or C++ if you would only point the way ...
Peter Sejr commented
How is this idea from 2015 and still not a thing - With the advances of Tabular models and Power BI, etc, I'm surprised this isn't implemented yet.
Would be such a usefull option.
Wyn Hopkins commented
I've now come across a client where this would be really useful
Luis Fajardo commented
I'm really hoping this will be added soon. How do you guys deal with this limitation in the meantime, a Data Analyst is given a Tabular Model to connect to and create analysis, but often there is the need to "extend" the model, at which point the Analyst has to "forget" about the powerful model and re-create something in his on by importing data to a local Excel Power Pivot Model, re-create the measures from the Tabular model and add his extensions.
Is this the story? What other way a Data Analyst has to "extend" a Tabular model other than recreating it as a local mini-model?
Marco Russo commented
Kenneth Barber commented
77 votes in <24 hours. That must be a new record.