Year To Date Calculations on Fiscal Years in Power Query

Year To Date Calculations on Fiscal Years in Power Query

Year To Date Calculations on Fiscal Years in Power Query

Working Excel File

This is the file I was using during the making of this YouTube tutorial. You can download it and follow along.

This is a video that is part of the “Your Questions Answered” Series, and as far as I’m concerned, this is one of the main reasons why I created this Channel. In this video, we will be answering a question that Dennis proposed. How do you create Year To Date (Running Totals in a Year) Calculations by Fiscal Years in Power Query? This comes down to a whole lot of Indexing Magic, Custom Year-Month Indexing, and Mod function.