When you use Power Pivot, there are a number of operations requiring more than one click (or much more than just Excel): Creating a pivot table based on the current data model (at least 2 or 3 clicks) Create a table of existing measures (including its  Read more

This short blog post is a note that could help myself in the future, or anyone who is interested in writing a client tool for Analysis Services. When you establish a session to Analysis Services, you can run both DAX and MDX statements. In DAX, you can  Read more

While I am teaching Mastering DAX and Optimizing DAX classes, I am always available to speech at local user group events. This week, I will present an updated version of the “Toolkit for DAX Optimization” in Amsterdam, on Thursday, November 26, 2016.  Read more

I recently write a small article on SQLBI to describe how to create a DAX measure that search for items that have all the items selected in a slicer, instead of any of them. For example, you might want to create a measure that display how many customers  Read more

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

Sep 22, 2015

Natural Hierarchies in Power Pivot and Tabular

Creating a hierarchy in a Power Pivot or Tabular data model is very easy, but you might experience performance issues if the hierarchy is not “natural”. This article explains how to create hierarchies avoiding these problems.  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