From the course: Power BI Data Methods

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Solution: Add a new column

Solution: Add a new column - Power BI Tutorial

From the course: Power BI Data Methods

Start my 1-month free trial Buy for my team

Solution: Add a new column

“

(upbeat music) - [Narrator] There are a couple ways to solve this problem, but here's how I did it. I first examined the table structure to figure out what fields would be useful to find the dates. For example, we could select the period or the month name to use as references to calculate the month number. I'm going to use the period field and extract the last two characters in it to find the actual month number. I'll add a new column to this table that I'll call Month. I'll then say Text.End. I'll then refer to period and I want the right two most characters, so I'll put a two in the second parameter. Now we see this returns 11, so it matches November. 10 matches October, and so on. While we're at it, let's also convert this new month field into a whole number. Like we can see on line 12, we can filter out the annual numbers by either removing month 13 from our month column, or we can remove the annual value from the month name. I'm going to choose the latter option and deselect…

Contents