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 »

PL-300 – Section 19: Part 2 Level 7 – View and Help Menus and Advanced Functionality Part 2

153. Advanced Editor In this video, we’re going to have a look at view Advanced Editor. And what it does is actually shows us the entirety of the steps that we have done in a particular query. So, let’s have a look at what we have. And first of all, we have the name at… Read More »

PL-300 – Section 19: Part 2 Level 7 – View and Help Menus and Advanced Functionality

150. Other M Functions Now, you may have noticed when we were doing the custom column that there are rather a lot of functions, and you might be thinking is this time for me to go through absolutely all of these functions and tell you what they do? The problem is, if I do that,… Read More »

PL-300 – Section 18: Part 2 Level 6 – Add Columns, View and Help Menus Section Part 2

144. Resolving Errors from Conditional Columns So, what we can do now is we can create any sort of visualisation but I just received a dialogue box saying that there are errors. Let’s have a look at the errors and you’re looking at these errors and you’re going oh my goodness, why are these errors?… Read More »

PL-300 – Section 18: Part 2 Level 6 – Add Columns, View and Help Menus Section

142. Column for Examples Hello, and in this section, we’ll be looking at the add column functions. Now, most of these functions, the from text, from number and from date and time are duplicates of the transform equivalent. So, we won’t be looking at those particularly. Instead we’ll be looking at the general. And we’ll… Read More »

PL-300 – Section 17: Part 2 Level 5 – Transform – Dates and Time Part 2

137. Transform/Add Column – Dates in Other Cultures/Languages Now, let’s say that you have got year, month and day in separate columns and you want to combine them together and then make a date. How can you do that? Well, you could use the merge columns feature, highlight the columns, and then merge columns. Now,… Read More »