Topic: Time Intelligence
-
The different results of DATEADD and PARALLELPERIOD in DAX may impact many other time intelligence functions that are syntax sugar of these two. Watch now
-
How to implement the comparison between school terms. The same technique can be applied to any arbitrary time periods that do not match regular months or quarters in a calendar, such as seasons or campaigns. Watch now
-
Every Power BI model has dates and the need for calculation over dates to aggregate and compare data, like Year-To-Date, Same-Period-Last-Year, Moving Average, and so on. Quick measures and standard time intelligence functions in DAX can help, but how do… Watch now
-
DAX provides a set of functions (Time Intelligence) to compute aggregations and comparisons over a range of dates: Year-To-Date, Same-Period-Last-Year, Moving Average, and so on. The DAX time intelligence functions can work well with a month granularity, but they have… Watch now
-
This video describes how we answer a question about an article: this time we show how to use the “Top N and others” report when there is a filter by date. Watch now
-
Why the standard DAX time intelligence functions might return unexpected results? Discover how DATEADD and SAMEPERIODLASTYEAR work under the hood! Watch now
-
How do you get the date of the previous order? The question came up in a comment to the article https://www.sqlbi.com/articles/understanding-the-difference-between-lastdate-and-max-in-dax/ Watch the video to see how we study the case and prepare our answer! Watch now
