Topic: DAX

        347 posts
DAX 101 –

Year-to-date filtering weekdays in DAX

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

DAX 101 –

Summing values for the total

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

article –

Semi-Additive Measures in DAX

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

blog post –

Using DAX with DateTime values

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