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 »
Grouping transactions by customers’ age requires a computation made row by row at transaction level. DAX offers an elegant solution… Read More »
This article contains a short checklist of what you have to do in order to optimize the memory used by… Read More »
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 »
When you use Excel to connect to a Tabular database in Analysis Services, you get a PivotTable as a result.… Read More »
With the modern editors that have automatic code formatting features, each one has its own code formatting style. Usually there… Read More »
In this article we see a function to enable parallelism in commands sent to Analysis Services by using the AMO… Read More »
Everyone using DAX is probably used to SQL query language. Because of the similarities between the Tabular data modeling and… Read More »
PowerPivot and Analysis Services 2012 Tabular do not support many-to-many (M2M) relationship directly in the data model. However, you can… Read More »
DAX is the new language used by PowerPivot and Analysis Services in Tabular mode and it resembles the syntax of… Read More »
Hierarchy handling in DAX is not very easy, due to the fact that hierarchies, unlike it was in MDX, are… Read More »
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 Analysis Services might be an important tuning of a correct setup, both for production and developer machines.… Read More »
VertiPaq is the internal column-based database engine used by PowerPivot and BISM Tabular models. High cardinality columns might be the… Read More »
PowerPivot and BISM Tabular handle relationships between tables by using a single column that requires to be a unique column… Read More »
If you want to execute a DAX query from your code to a Tabular model, you might think that an… Read More »
When you design a data model for Tabular you should pay attention to a though topic, which is that of… Read More »