Add a Fiscal Month, Quarter or Year Column in Power Query | Excel Off The Grid
10.9 هزار بار بازدید -
پارسال
-
★ Want to automate Excel?
★ 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
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
پارسال
در تاریخ 1402/05/19 منتشر شده
است.
10,995
بـار بازدید شده