Analyzing Data over Time with DAX
Most data analysis—and nearly all business intelligence—involves looking at how metrics evolve over time. You may need to aggregate sales by month, week, or year, for instance. Perhaps you want to compare figures for a previous month, quarter, or year with the figures for a current period. Whatever the exact requirement, handling time (by which I nearly always mean dates) is essential in Power Pivot.