The second edition of the Mastering DAX video course is available!  Read more

This article describes how to correctly use column references when manipulating tables assigned to DAX variables, avoiding syntax errors and making the code easier to read and maintain.  Read more

A few weeks ago I woke up on a Saturday morning with a question notified on my Quora feed: Why do all the BI consultants hate DAX? I was challenged to answering the question because I personally love DAX but…  Read more

SQLBI is now offering a new Data Modeling video course: Introduction to Data Modeling for Power BI. This article describes which users will benefit from this learning experience the most, and how to enroll in the course.  Read more

Microsoft announced at SqlBits a very important feature for DAX: Calculation Groups. These are my first impression about the new feature and the impact it will have on Analysis Services and Power BI.  Read more

This article describes how to display the filter context applied to a calculation using a special DAX measure in Power BI Tooltips.  Read more

This article describes how to write DAX measures that compute aggregations or comparisons with past dates without showing or comparing future dates.  Read more

This week OKViz released Smart Filter Pro 2.0.5, which is the first commercial version of a custom visual for Power BI produced by OKViz. This is the first of other rich and advanced visuals that will be released in the…  Read more

Yesterday I answered to a question related to parameters in DAX that could be useful to other readers who use DAX in Reporting Services (SSRS): how to manage missing parameters of a DAX query? I wrote an article in the…  Read more

This article describes the real meaning of and the required action for a few common error messages that can appear when users define DAX expressions in Power BI.  Read more