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 »
PL-300 – Section 24: Part 3 Level 2 – An Introduction to DAX Functions, Including Logical Functions
179. DAX Functions – A Useful Resource Now, that we’ve got our model set up. We will now be correcting calculated columns in this section, and calculated measures. But as I’ve said previously, it uses a different language, and it’s called DAX. D. A. X. So, what I’ve done, is attached as a resource, to… Read More »
PL-300 – Section 22: End of Part 2
172. End of Part 2 Well, congratulations. We are halfway through the course. You’ve now got to the end of part two. So, let’s just have a look at some of the requirements of the PL-300 exam. So in this part, you’ll have seen how you can get data from different data sources. So, you… Read More »
PL-300 – Section 20: Part 2 Level 8 – Get Other Types of Data Part 3
162. Setting up Azure SQL Database in Power BI Over the next two videos we’ll be connecting to Azure, Azure SQL Database. Now, what is Azure? Well, Azure is a managed cloud database. So, it is service, which is this final “S”. But it is also software which is this first “S”. “Software as a… Read More »
PL-300 – Section 20: Part 2 Level 8 – Get Other Types of Data Part 2
160. Expanding Multiple Tables in SQL Server What I’m going to do is say actually, what I want is the name. I want the category, the subcategory and the category. So, let’s move across and say I want the category and subcategory. Remember, we’ve only imported one table. Subcategory is in another table. There was… Read More »
PL-300 – Section 20: Part 2 Level 8 – Get Other Types of Data
157. Introduction to SQL Server Hello and in this section of what we’re going to do, concluding our look at the Power Query section of Power BI, is connecting to various different data sources. Now, there are obviously, a huge number of data sources and we can’t possibly go through them all. So, what we’re… Read More »
