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 »

PL-300 – Section 14: Part 2 – Getting Multiple Files Part 2

115. Appending Three or More Queries Together + Resolving a Problem with Data Types Now, let’s get in a third query. So, I’m going to now get my March data back in. So, I’m going to March and drag that in. So, there we go. And now, let’s delete my pended query and now I… Read More »

PL-300 – Section 40: End of Part 4

297. End of Part 4 Well, congratulations. You finished the coals and finished part four. So, let’s have a reminder of what we’ve been doing in part four. Well, first of all, we had to look at the Power BI Service itself, because none of these things that you see on the screen, which are… Read More »

PL-300 – Section 14: Part 2 – Getting Multiple Files

112. Merge Queries and Expand Table In this video we’re going to have a look at merge queries, the first of the combined. And what we’re going to do is I’m going to get rid of almost everything that we did in last few sections. Just have it so that we have our raw data.… Read More »

PL-300 – Section 13: Part 2 Level 1 – Get Data – Home

107. Sort and Filter Now, it’s possible that you don’t have the data in the order that you want especially if you’re going to reduce rows by removing the top few rows or the bottom few rows. So, maybe, you didn’t want the very first ones where the Filename starts with the very start of… Read More »

PL-300 – Section 12: Part 2 Get and Transform Data: Level 1 – Home Part 2

101. Introducing the M Language In the last video, we had a look at the fact that there were formulas in the formula bars. But these are very different types of formulas than are available in Excel. You’ll notice that each of these formulas are in two parts. There is a word, and then a… Read More »