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 »

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 »