From the course: Complete Guide to Power BI for Data Analysts by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,300 courses taught by industry experts.

Basic time intelligence functions

Basic time intelligence functions

- [Instructor] Okay, so in this sub-lesson, we are going to talk about basic time intelligence functions. A very common action in any analytics reporting is to do your an analytics over some type of time horizon and the time intelligence functions really help out with that. The first thing I want to do is I'm actually on my report view and this is the report that we previously had built. And you'll notice one thing about it and that is the fact that the order date is now showing the individual order dates. Now keep in mind back in a previous sub-lesson, we had disabled the auto date time and this visual needs some correction. So what we're going to do is I'm just going to make sure the visual is highlighted. I'm going to go ahead and remove the order date here. Let's just go ahead and get rid of it and then I'm going to grab this order date year, which we had created back in our date table, and just drop it there. So we're now back to way that it looked previously because before we…

Contents