© Philip Seamark 2018
Philip SeamarkBeginning DAX with Power BIhttps://doi.org/10.1007/978-1-4842-3477-8_7

7. Dates

Philip Seamark1 
UPPER HUTT, New Zealand

Most data models involve an element of date or time. I can’t remember the last time I worked on a data model that didn’t involve date values anywhere in the data.

Business data invariably involves tables of transactions that include a point-in-time value . Sometimes a row of data might carry multiple DateTime fields to represent different actions relevant to that transaction. In the case of a customer order, there may be values to show the point in time of the original order, the pick-up date, the delivery date, and the invoice date. Downstream reporting requirements may need to group data ...

Get Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.