Topic: Time Intelligence
Optimizing LASTNONBLANK and LASTNONBLANKVALUE calculations
This article explains the behavior of LASTNONBLANK, LASTNONBLANKVALUE, and similar DAX functions, also providing patterns for performance optimization. Read more
Comparing with previous selected time period in DAX
This article describes how you can create a comparison with the previous time period in a visualization, regardless of whether the time periods are consecutive or not. Read more
Sorting months in fiscal calendars
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
Previous year up to a certain date
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
Automatic time intelligence in Power BI
This article shows why building custom Date tables is preferable to using the automatic date/time handling capabilities of Power BI. Read more
Creating a simple date table in DAX
This article shows how to build a basic date table using a calculated table and DAX. Read more
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
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
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
Computing running totals in DAX
This article shows how to compute a running total over a dimension, like for example the date. Read more