Chapter 4. Working with date and time

In business models, you typically compute year-to-date (YTD), year-over-year comparisons, and percentage of growth. In scientific models, you might need to compute forecasts based on previous data or check the accuracy of numbers over time. Nearly all these models contain some calculations related to time, which is why we have dedicated a full chapter to these kinds of calculations.

In more technical terms, we say time is a dimension, meaning you typically use a Calendar table to slice your data by year, month, or day. Time is not just a dimension, however. It is a very special dimension that you need to create in the right way and for which there are some special considerations.

This chapter shows several ...

Get Analyzing Data with Power BI and Power Pivot for Excel, First Edition 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.