Using Date Tables In Power Pivot
Power Pivot is causing many business professionals to re-think how they create reports and analyses. However, for those that need to summarize data based on fiscal periods – instead of calendar periods – reporting in Power Pivot can be a bit cumbersome and challenging. Fortunately, there is a very easy-to-use solution – date tables – and in this tip, you will learn how you can add date tables to speed the process of reporting based on fiscal periods in Power Pivot.