Convert Dates to Fiscal Periods with Power Query - Better than Formulas!
It's more efficient for Excel to add columns for your fiscal periods with Power Query than it is with formulas. In this video I'll cover both fiscal periods that start at the beginning of a month and those, like a 4-5-4 calendar, that don’t.
Download the Excel file here: https://www.myonlinetraininghub.com/excel-convert-dates-to-fiscal-quarters-and-years
Learn Power Query: https://www.myonlinetraininghub.com/excel-power-query-course
View my comprehensive courses: https://www.myonlinetraininghub.com/
Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/
Видео Convert Dates to Fiscal Periods with Power Query - Better than Formulas! канала MyOnlineTrainingHub
Download the Excel file here: https://www.myonlinetraininghub.com/excel-convert-dates-to-fiscal-quarters-and-years
Learn Power Query: https://www.myonlinetraininghub.com/excel-power-query-course
View my comprehensive courses: https://www.myonlinetraininghub.com/
Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/
Видео Convert Dates to Fiscal Periods with Power Query - Better than Formulas! канала MyOnlineTrainingHub
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![How to Build Power BI Reports from Start to Finish](https://i.ytimg.com/vi/Z2t7l8b1uWU/default.jpg)
![Power Query Unpivot - fix 4 common data layouts (incl. workbook)](https://i.ytimg.com/vi/-IMqkg35adA/default.jpg)
![How to easily automate boring Excel tasks with Power Query!](https://i.ytimg.com/vi/L4BuUzccLpo/default.jpg)
![Reduce VBA Errors by 90% (with this little-known Method)](https://i.ytimg.com/vi/CT7XkPXKVFw/default.jpg)
![Writing a DAX query using TOPN](https://i.ytimg.com/vi/tgL7D3JTa_E/default.jpg)
![Excel Mini Charts - Better than Sparklines!](https://i.ytimg.com/vi/ody_09oUaHY/default.jpg)
![Convert Dates to Fiscal Periods in Excel - Easy Formula](https://i.ytimg.com/vi/jQ1l1cqmj7Y/default.jpg)
![50 Ultimate Excel Tips and Tricks for 2020](https://i.ytimg.com/vi/FXs3WG7M-qk/default.jpg)
![Excel Keyboard Shortcuts used by Pros](https://i.ytimg.com/vi/4xanM8XD058/default.jpg)
![Excel Searchable Drop Down List - No VBA and No Formulas!](https://i.ytimg.com/vi/NqvB-DqIuP4/default.jpg)
![Excel Dashboard - Plan vs Actual Variances - FREE Download](https://i.ytimg.com/vi/_PlBRWc0RlI/default.jpg)
![Excel XLOOKUP Function Definitive Guide](https://i.ytimg.com/vi/2ViMm-wuM3U/default.jpg)
![Power Query Overview - Automate Data Tasks in Excel & Power BI](https://i.ytimg.com/vi/vq9AgAtSvQg/default.jpg)
![Easily Fix Dates Formatted as Text with Power Query](https://i.ytimg.com/vi/0RN3FZv3w84/default.jpg)
![Exciting New Excel LET Function - Comprehensive Guide](https://i.ytimg.com/vi/o3ysGnl8ieM/default.jpg)
![Interactive Excel Project Management Dashboard - FREE Download](https://i.ytimg.com/vi/5qtSioTE2wY/default.jpg)
![10 awesome things you can do in Excel - WITHOUT any formulas or pivots](https://i.ytimg.com/vi/W1QhTQCasb4/default.jpg)
![Excel PivotTable Calculated Items](https://i.ytimg.com/vi/KllJjHndlqA/default.jpg)
![Excel PivotTables Made Easy - And Why Things Go Wrong!](https://i.ytimg.com/vi/vQlFiLUaw4k/default.jpg)
![Easy Excel PivotTable Profit & Loss Statements](https://i.ytimg.com/vi/5kUQSxBVlZ8/default.jpg)