O'Reilly logo

Pro Power BI Desktop by Adam Aspin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© 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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required