PL-300 – Section 32: Part 4 Section 1 – An Introduction to the Power BI Service Part 2

246. Power BI Terminology In this video, we’re going to have a look at some of the key Power BI service terminology. And we’re going to start off with data sources. Now, data sources are where your data has come from. So, it could be that it’s come from an Excel spreadsheet, a CSV, comma… Read More »

PL-300 – Section 31: Part 3 Level 9 – Other Modeling and DAX Topics for the Exam Part 2

239. 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 many-to-many 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,… Read More »

PL-300 – Section 32: Part 4 Section 1 – An Introduction to the Power BI Service

243. Welcome to Part 4: The Power BI Service Hello, and welcome to part four of this course, and here we’ll finish off the PL-300 requirements, so let’s see what we’ve got. We will be creating dashboards, we’ll be managing files and datasets, managing workspaces, and doing a little bit on getting data from different… Read More »

PL-300 – Section 31: Part 3 Level 9 – Other Modeling and DAX Topics for the Exam

235. 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… Read More »

PL-300 – Section 30: Part 3 Level 8 – Time Intelligence Functions

223. 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 we’ll… Read More »

PL-300 – Section 29: Part 3 Level 7 – Filter and Value Functions Part 3

216. FILTER Now, suppose I didn’t want the entirety of the table which all does, all changes the context to the 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… Read More »

PL-300 – Section 29: Part 3 Level 7 – Filter and Value Functions Part 2

213. RELATEDTABLE and COUNTROWS So, that’s all very well going from the many to the one, but what if I wanted to go from the one to the many? For example, I have these categories. What if I want to know for each category what the total number of sales or the total standard cost… Read More »

PL-300 – Section 29: Part 3 Level 7 – Filter and Value Functions

211. RELATED – Flatten Out a Parent-Child Hierarchy Now, this section is all about the filter 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 look like a vertical lookup… Read More »

PL-300 – Section 28: Part 3 Level 6 – Information Functions

207. ISERROR and LOOKUPVALUE A quick section on information functions, and one of the functions I probably use the most, is ISBLANK, we’ve had a look at this already, ISERROR is fairly related to IFERROR which sees if there’s an error in the value, and replaces it with something else. So, for instance, I could… Read More »

PL-300 – Section 27: Part 3 Level 5 – Text Functions

201. Text Searching Now, in this section we’ll be looking at the various text functions. And we’ll start with FIND and SEARCH. They’re almost exactly the same as in Excel, but there is one particular hitch that you need to be aware of. So, FIND, will find a particular phrase within another phrase. Or, maybe,… Read More »