Topic: Excel

        Page 3 of 57 posts
blog post –

Execute a #DAX Query on #SSAS #Tabular in #Excel

Apparently Excel does not offer a way to import data in Excel by using a DAX query on Analysis Services. The Data Connection Wizard seems to offers only the ability to create a PivotTable when you connect to Tabular, but not a Table (see the Table option  Read more

blog post –

PowerPivot Compatibility across versions

There are several versions of PowerPivot available and starting with Excel 2013 there are also several versions of Excel. It is useful to look at the compatibility between the different versions of Excel and PowerPivot available now. As a general rule  Read more

article –

Rules for DAX Code Formatting

With the modern editors that have automatic code formatting features, each one has its own code formatting style. Usually there are a few “common rules” for code formatting depending on the language, but there was nothing for DAX  Read more