Topic: Time Intelligence
-
The DAX language provides several Time Intelligence functions that simplify writing calculations such as year-to-date (YTD), year-over-year (YOY) and so on. However, if you have a special calendar structure such as a 4-4-5 weeks’ calendar, you need to write your… Read more
-
This article explains the behavior of LASTNONBLANK, LASTNONBLANKVALUE, and similar DAX functions, also providing patterns for performance optimization. Read more
-
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
-
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 why building custom Date tables is preferable to using the automatic date/time handling capabilities of Power BI. Read more
-
This article shows how to build a basic date table using a calculated table and DAX. 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 write DAX measures that compute aggregations or comparisons with past dates without showing or comparing future dates. Read more
-
You might have used FIRSTNONBLANK and LASTNONBLANK in semi-additive measures, but you might not be aware that their use is not limited to time intelligence functions. This article shows alternative scenarios where these functions are useful. 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