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 »
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 »
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 »
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 »
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 »
VertiPaq vs ColumnStore Comparison
SQL 2012 gives you two different xVelocity engines, with different capabilities and different scenarios of implementation, the paper will help… 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 »
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 »
From SQL to DAX: String Comparison
In DAX string comparison requires you more attention than in SQL, for several reasons: DAX doesn’t offer the same set… Read More »
From SQL to DAX: Projection
Using DAX as a query language you will lack a fundamental feature like projection. In fact, DAX allows you add… Read More »
Videos available from SQLBits
We presented a few session at SQLBits and the video of these sessions are available. This is the list of… Read More »
Converting MDX to DAX – First Steps
A BISM Tabular model can be queried by using both MDX and DAX. These two different languages rely on different… Read More »
KEEPFILTERS: a new DAX feature to correctly compute over arbitrary shaped sets
Having read this question on the mdsn blogs, I investigated on the KEEPFILTERS function and, after having learned it, it is… Read More »