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 »

PL-300 – Section 26: Part 3 Level 4 – Mathematical Functions

193. Introduction to Mathematical Functions Hello everyone and congratulations for making it through to this section. In this section, we’ll be having a look at the Mathematical functions within the DAX language. They operate very similarly to those in Excel. If you already know how to use rounding functions in Excel, then you might want… Read More »

PL-300 – Section 25: Part 3 Level 3 – Statistical Functions

188. Measures – an Introduction, with Standard Aggregations including Countblank In this part of the course, what we’re going to do is have a look at not new columns, though, we will be using what we’ve learnt in the previous session in the future part of this course, but also new measures. Now, we’ve used… Read More »