Microsoft PowerPivot for Excel 2010: Date Calculations in DAX
- 10/5/2010
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.