Add a Fiscal Month, Quarter or Year Column in Power Query | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy

★ Check out the blog post★
https://exceloffthegrid.com/power-que...

★ About this video ★
Over the last few months, I've been asked several times how to add a fiscal year, fiscal quarter, or fiscal month column in Power Query. So I decided to note down the method so I don't have to keep reminding myself how I did it last time.

The good news is that it's reasonably straightforward. So let's see what we need to do.

CONTENTS
0:00 Introduction
0:31 Example Data
1:12 Fiscal Month
3:13 Fiscal Year
4:48 Fiscal Quarter
6:11 Conclusion

★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/

★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter: Twitter: exceloffthegrid

#MsExcel