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 »
When you use Excel to connect to a Tabular database in Analysis Services, you get a PivotTable as a result.… 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 »
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 »
In many workshops and sessions about PowerPivot the most frequently asked question has always been: how can I automate the PowerPivot Data… Read More »
In PowerPivot you can import data from several sources and it is often the case that you import a DateTime… Read More »
In an Analysis Services cube you can define drillthrough actions on a cube. This feature has been working since SQL… Read More »
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 »