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

This article shows how to compute a measure that sums the values produced row by row in the visual into the visual total, instead of recomputing the total value in the filter context of the total.  Read more

Values such as inventory and account balance, usually calculated from a snapshot table, require the use of semi-additive measures. This article describes how to implement these calculations in DAX according to your specific requirements.  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

I was recently reading an interesting question by a user. Given a date/time value and a number of hours, add the number of hours to the date, but considering some constraints related to working hours: The working hours are 09:00-17:00…  Read more

This article shows a DAX technique to compute the number of working days between two dates.  Read more

This article shows how to compute a running total over a dimension, like for example the date.  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