Home > Sample chapters > Microsoft Office > Excel

Microsoft PowerPivot for Excel 2010: Date Calculations in DAX

Summary

In this chapter, you saw how to create a Dates table for a PowerPivot model and how to use that table to support several types of calculations: number of working days, aggregation and comparison over time, and closing balance over time.