Numbering sequence of events in DAX
This article explains how to create a calculated column in DAX to get a sequential number identifying the events related to a particular entity.
In a model optimized for DAX, you should split date and time in two different columns in order to improve the compression and the usability of the data model. A negative side effect of this design choice is the complexity involved in calculations that have to relate events in sequence. For example, consider this table containing sales of products by date, time, and customer.