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

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 build a basic date table using a calculated table and DAX.  Read more

This article shows why building custom Date tables is preferable to using the automatic date/time handling capabilities of Power BI.  Read more

This article showcases the use of CONCATENATEX, a handy DAX function to return a list of values in a measure.  Read more

This article describes how to compute previous year values up to a certain date. This is useful in case the data is presenting incomplete months or years.  Read more

This article shows a basic technique used to sort months according to a fiscal calendar, by using a couple of calculated columns and the “sort by column” feature of Power BI.  Read more

This article shows how to use the USERELATIONSHIP function in DAX to change the active relationship in a CALCULATE function.  Read more