Index Column and Duplicate Column Now, in the previous video, we saw that there was an error on row 721, but we may have been finding it a bit difficult to find exactly where row 721 was. So one thing we can do in our query is add a new column which just has a list of the raw numbers. And this is called an index column. Now, index columns, well, in real life, start with one. So row one, row two, row three, but you might want them starting…

Column from examples Hello. And in this section we’ll be looking at the add column functions. Now, most of these functions 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 start off with column from examples. And it could be you have have an example of something and you want the computer to work out. What exactly are you trying to do? So let’s create a new…

Introduction to SQL Server Hello. And in this section, 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 going to do is look at the requirements of the official All Microsoft exam and so what we’ve got is connect to files and folders. Well, we did that previously when we had a look at January…

Resolve problems Hello and welcome to this final level of part two. And in this part we’re going to have a look at certain aspects of the DA 100 exam that didn’t quite fit nicely into the other eight levels. Now we’re going to actually start with a few items that we’ve actually covered, but which we may not have covered, and said this is how you can do something. So what I’ve done is I’ve just imported our basic Pivot table HPI regions free. Now, there are some inconsistencies….

Basic operators So let’s have a look at some basic operators that you can use. And you probably won’t be too surprised which operators these are, especially if you come from the Excel mode. So we’ve got multiply, we’ve got divide, we’ve got subtract and we’ve got add and we’ve also got the Carrade, which on my keyboard is shift six and that is to the power of so you can square something with Carra two for instance. So nothing majorly new here. You might just want to know, by…

Welcome to Part 3 – Modeling and DAX functions Hello and welcome to part three of this course, which is all about modeling the data. And you can see in blue the requirements of the DA Dash 100 exam. And I think it’s a good template to follow. So we’ll be designing a data model, we’ll be developing it, we’ll be creating measures by using DAX and we’ll be optimizing the model performance. So what, what is this section all about? Well, we have got the data, we have transformed…

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 measures quite a lot in part one of this course. Whenever you drag anything through to a visualization it’s quite often if it’s numerical going to be measure. So previously we had this sales territory and…

Rounding functions In this section of the course, I Want to Talk about mathematical Functions and Want to address a Problem that we had to look at a few sections ago. Now, the sales amount, I’ve done a Filter on this so that we’re just talking about the 1 August and we’re talking about product key five to eight. So that just Gives us six rows. The sales amount is 499 for each of these items. So 499 and the six items gives us 29 pound. 94. That’s good. That’s…

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 a letter within a phrase by default, starting at at the first position. So right at the beginning, and if not, starting wherever you want it to start. Now, this is one sensitive base one M…

ISERROR and LOOKUPVALUE A quick section on information functions. And one of the functions I probably use the most is blank. We’ve had a look at that already. Is error is fairly related to if error, which sees if there’s an error in the value and replaces it with something else. So, for instance, I could would say is error four divided by zero. Now that tells me whether this value contains an error. Now if error would then say, well, if that’s the case, then replace it with something…