Channel: MrExcel.com

Category: Howto & Style

Tags: excelusing power query to link to a calendar in excelfiscal calendar in excelexcel pivot tablemrexcelfiscal years in excelpivot tablemicrosoft excelbill jelenfiscal years in excel pivot tables

Description: Check out my Excel Guides on Retrieve: mrexcel.retrieve.com/store/# A question from the Las Vegas IMA: How do you do date rollups in Excel when the company is on a fiscal year that does not end on December 31? This video shows how to use Power Query to link to a Calendar table. The pivot table uses the Data Model and you create a relationship.