Import Data from Tabular Model in Excel Using a DAX Query
When you use Excel to connect to a Tabular database in Analysis Services, you get a PivotTable as a result.… Read More »
Linkback Tables in PowerPivot for Excel 2013
In PowerPivot for Excel 2010 it is possible to import an Excel table in a PowerPivot data model by using… Read More »
Upgrading PowerPivot from Excel 2010 to Excel 2013
If you have a PowerPivot workbook created with Excel 2010, in order to navigate and/or update the data model with… Read More »
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… Read More »
Usage of dates argument in a row context
Several Time Intelligence functions in DAX use a <dates> argument, which has a special behavior because it can be expressed… Read More »
Automate PowerPivot Data Refresh in Excel
In many workshops and sessions about PowerPivot the most frequently asked question has always been: how can I automate the PowerPivot Data… Read More »
DateTool dimension: an alternative Time Intelligence implementation
Year-To-Date and Difference-Over-Previos-Year (or Year-Over-Year Growth) are among the most required features of any user. Some OLAP client (like ProClarity)… Read More »