© Adam Aspin 2016

Adam Aspin, Pro Power BI Desktop, 10.1007/978-1-4842-1805-1_9

9. Analyzing Data over Time

Adam Aspin

(1)Stoke-on-Trent, Staffordshire, UK

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 we nearly always mean dates) is essential in Power BI Desktop.

Initially, using time functions in Power BI Desktop may only be limited to extracting time intervals from the available data and grouping results by units of time, such as days, weeks, months, ...

Get Pro Power BI Desktop now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.