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 »

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

135. Creating a List of Dates Hello. In this section, we’re going to have a look at dates and times, and we’re going to start by getting data, but not from out friend the PowerBIData spreadsheet. Instead, we’re going to start with a blank query. So, there’s some interesting things we can do with a… Read More »

PL-300 – Section 16: Part 2 Level 4 – Transform – Text and Numbers Part 2

129. Transform/Add Column – Text – Extract Now, in this video, we’re going to have a look at the Extract functions. Now, there may be a bit of similarity with Split Column, because we are able to split a column by delimiter. So, if we take this region, for example, and split this column by… Read More »

PL-300 – Section 16: Part 2 Level 4 – Transform – Text and Numbers

127. Transform/Add Column – Text – Format In our practise activity that we just did, I created this year analysis, and it’s looking, okay, fairly good. It gives me information, it gives me, for instance, that East of England and Southwest keep changing places. But the thing that it doesn’t quite do if you have… Read More »

PL-300 – Section 15: Part 2 Level 4 – Transform Menu Part 2

121. Unpivot Now, in this video, what we’re going to do is to unpivot. So, we’ve got a pivot table here, now to unpivot in Excel, if they still give you, whoever they is gave you the data, if it’s still in a pivot table form, then to unpivot all you have to do is… Read More »

PL-300 – Section 15: Part 2 Level 4 – Transform Menu

119. Transform – Table and Any Column In this section, we’re going to have a look at the transform menu, and specifically, tables, any column, text column, and number column. There’ll be some revision in this, partly because there’s revision in here already. A lot of this is in the home menu that we had… Read More »