Grouping Transactions by Age of Customers in DAX
Grouping transactions by customers’ age requires a computation made row by row at transaction level. DAX offers an elegant solution… Read More »
Checklist for Memory Optimizations in PowerPivot and Tabular Models
This article contains a short checklist of what you have to do in order to optimize the memory used by… Read More »
Week-Based Time Intelligence in DAX
The DAX language provides several Time Intelligence functions that simplify writing calculations such as year-to-date (YTD), year-over-year (YOY) and so… Read More »
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 »
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 »
Parallelize ProcessAdd with AMO
In this article we see a function to enable parallelism in commands sent to Analysis Services by using the AMO… Read More »
Best Practices Using SUMMARIZE and ADDCOLUMNS
Everyone using DAX is probably used to SQL query language. Because of the similarities between the Tabular data modeling and… Read More »
Optimize Many-to-Many Calculation in DAX with SUMMARIZE and Cross Table Filtering
PowerPivot and Analysis Services 2012 Tabular do not support many-to-many (M2M) relationship directly in the data model. However, you can… Read More »
Order of Evaluation in CALCULATE Parameters
DAX is the new language used by PowerPivot and Analysis Services in Tabular mode and it resembles the syntax of… Read More »
Clever Hierarchy Handling in DAX
Hierarchy handling in DAX is not very easy, due to the fact that hierarchies, unlike it was in MDX, are… Read More »
Incremental Processing in Tabular Using Process Add
In Analysis Services 2012 you can process a table in a Tabular model by several ways: you can process the… Read More »
Memory Settings in Tabular Instances of Analysis Services
Memory settings in Analysis Services might be an important tuning of a correct setup, both for production and developer machines.… Read More »
Optimizing High Cardinality Columns in VertiPaq
VertiPaq is the internal column-based database engine used by PowerPivot and BISM Tabular models. High cardinality columns might be the… Read More »
Budget and Other Data at Different Granularities in PowerPivot
PowerPivot and BISM Tabular handle relationships between tables by using a single column that requires to be a unique column… Read More »
Execute DAX queries through OLE DB and ADOMD.NET
If you want to execute a DAX query from your code to a Tabular model, you might think that an… Read More »
Understanding Circular Dependencies in Tabular and PowerPivot
When you design a data model for Tabular you should pay attention to a though topic, which is that of… Read More »