From the course: Advanced Power Query
Join today to access over 24,600 courses taught by industry experts.
Calculating the fiscal year for dates: Example 2
From the course: Advanced Power Query
Calculating the fiscal year for dates: Example 2
- When we have done the calculation for financial quarter in Power Query, it's quite unsettling that we don't have fiscal year calculation as of yet. Well, in this video, we're going to do just that. Let's start with financial year calculation in Power Query. Let's just see if we can modify the standard year calculation in Power Query and also calculate the fiscal year just as the way that we did for Financial Quarter. I'm going to start by loading this data inside of Power Query. So I'm going to go over to the Data tab and click on From Table/Range, and that's where the data has been loaded. Now obviously this is showing the data type as a date time, which I will obviously change it to a date and I will replace the current step. Now I can click on the column and I can go over to the Add Columns tab, click on Date, and then find the year of that particular date, which is the calendar year of that date. Now, I want to customize this to the fiscal year, and the logic is going to be…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.