This article shows how to build a basic date table using a calculated table and DAX.  Read more

Time intelligence functions oftentimes hide an automatic ALL statement meant to make time intelligence calculations easier. This article describes this behavior and what to do in case it ends up breaking your calculation.  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

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

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 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