FILTER Now, suppose I didn’t want the entirety of the table, which all does all changes the context as a zoom out and getting all of the rows. What if I wanted to go from my starting point, which is the context, and go even further down? Let’s take an example. Let’s get back to having our product duct standard cost and that there is a field called promotion key. And you can see that the vast majority of the sales have been on promotion key, 115 million for bikes…

RELATED Now, this section is all about the photo functions and these are the ones which have absolutely no comparison with Excel functions. Now, these first two sort of do because we previously had a look at vertical lookup tables or something that looked like a vertical lockup table, which was the lockup value function. But you may remember it’s a big, it complicated. The related function which we are looking in this particular video is a lot simpler. And the reason for that is it’s using the relationships that…

Date and Time Functions Hello. In this section, what we’ll be doing is looking at time intelligence functions. These are functions that are not usually included in Excel. But before doing that, I just want to have a look at all of the date and time functions, excluding the time intelligence functions that will get on to in later videos. So if you’re used to them in Excel, or if you’re used to them in the language, then it’s fairly simple. So we’ve got date. Date specifies a date. It…

Resolve many-to-many relationships – Different types of granularity In this video we’re going to have a look at another reason why you might have a manytomany relationship and that is detailed data on both sides of the relationship. So if we go into our data and have a look at the other two spreadsheets which are marked M to M, which are actual and target, you can see what we’ve got in the target. We have have this company which operates out of Western Europe and it’s anticipating the amount…

Create calculated tables Hello and welcome to this last level of part three. And in this level, we’re going to have a look at all of the items from the DA 100 certification that haven’t fitted neatly into the other levels. Now, in a previous level, in part two, we had a look at the Drive Safely text files, and I’m just going to use this text file as an example of how we can create a calculated table. So here we have the data. I’m just going to put…

Datasets and Reports in the Power BI Service In this video we’re going to have a look at data sets and reports and how they are shown in the Power Bi service. So here I am back in the Power Bi service back at home and you’ll see that we have got dashboards reports, workbooks and datasets and we can collapse any of those by just clicking on the word. So here I’ve collapsed absolutely everything but it’s a bit difficult to know where data sets start so it’s slightly…

Signing up for Power BI Pro Hello and welcome to part four, section two of this Power Bi course. And in this section we’ll be looking at Power Bi Pro. Power Bi Pro is for sharing and so we need some new users. So what I have done is I have signed for completely new account and I’ve done that by using Office 365 or Microsoft 365. They’re changing the name. It’s the Microsoft Office online thing which I showed you in one of the earlier videos right at the…

Welcome to Part 4: The Power BI Service Hello and welcome to part four of this course. And in this part, we’ll be finishing off looking at the DA 100 requirements. So let’s just see what we’ve got. We’ve got creating dashboards, we’ve got managing data sets, we’ve got to create and manage workspaces. Now, before all of that, we have to know what on earth the power bi service is. So 1st, first of all, we will be looking at the terminology in the power bi service because the…

Adding role-based Row Level Security In the previous video, we created this report and we shared it with Susan and Jane. But Jane should only be able to see bikes and Susan should only be able to see accessories and clothing. So we need to implement some security. And we implement the security on the data set. So let’s go to our data set here and click on the and we have a security setting. So we click on that and we should easily be able to add the level…

Differences between dashboards and reports Hello. In this section, we’re going to have a look at dashboards in the power bi service. Now, dashboards and reports sound similar. So what we’re going to do first of all in this video is look at the differences between dashboards and reports. Then we’re going to look at the options associated to do dashboards, and then we’re going to take each of the requirements in the DA 100 exam as a separate video. So some of these videos might be very short, but…