★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/'>https://exceloffthegrid.com/academy'>https://exceloffthegrid.com/'>https://exceloffthegrid.com/academy
★ Check out the blog post★
https://exceloffthegrid.com/'>https://exceloffthegrid.com/powerque...
★ 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/'>https://exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter: / exceloffthegrid
#MsExcel