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 - Power BI Tutorial
From the course: Complete Guide to Power BI for Data Analysts by Microsoft Press
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
-
-
-
-
-
-
(Locked)
Learning objectives29s
-
(Locked)
Build a date table5m 29s
-
(Locked)
Disable the auto date/time setting3m 50s
-
(Locked)
Designate a date table3m 1s
-
(Locked)
Build relationship between order date and sales3m 1s
-
(Locked)
Basic time intelligence functions8m 10s
-
(Locked)
Use the CALCULATE function2m 30s
-
(Locked)
-
-
-
-
-
-
-