Last week we launched a new page in SQLBI website: DAX Puzzle (you can also use www.daxpuzzle.com ). The idea is very simple: we describe a scenario, we ask to solve a problem in that scenario and we might provide some hint to help you finding the solution.  Read more

I am so happy to announce that The Definitive Guide to DAX is finally available! I and Alberto Ferrari spent one year writing this book, and several years collecting the knowledge necessary to do that. The complete title is The Definitive Guide to DAX:  Read more

If you use SSAS Tabular, this is a very important news! Microsoft released a very important update for Analysis Services 2012 that provides performance improvements to pivot tables connected to an Analysis Services Tabular model: it is SQL Server 2012  Read more

Almost 3 years ago I wrote an article with the rules for DAX code formatting . If you quickly look at the article, you might think that it is all about readability of the code, and this is fundamentally true. But there two rules that have a particular  Read more

The growing adoption of Power BI Desktop is gathering new users of the DAX language. At the same time, there are a few new features, such as bidirectional filter propagation, that introduce new concepts to existing knowledge. For this reason, in the last  Read more

After many years of helping several companies around the world creating small and large data models using SQL Server Analysis Services Tabular, I’ve seen a common performance issue that is underestimated at design time. The VertiPaq engine in SSAS Tabular  Read more

I and Alberto Ferrari recently completed the writing of The Definitive Guide to DAX , and we spent months to correctly describe the internals of evaluation context in this language. There are many details that make data model working with both DAX and  Read more

During the writing of The Definitive Guide to DAX I wanted a simple way to analyze the content and distribution of data compressed in the VertiPaq engine, used by Analysis Services Tabular, Power Pivot and Power BI models. I always relied on BISM Memory  Read more

In the last months I assisted many companies implementing solutions based on Analysis Services Tabular. There is not so much difference between the versions 2012 and 2014, because SQL Server 2014 didn’t introduce new features to the BI services. Thus,  Read more

In the last few weeks I and Teo Lachev took the ownership of DAX Editor code. It is an add-in for Visual Studio that allows you to edit DAX measures in a text editor instead of using the Measure grid. It also provides other features (such as editing measures  Read more