We help IT Professionals succeed at work.

DAX logic to calculate time between two rows

113 Views
Last Modified: 2018-03-28
I have this data:

ID  LicencePlate    Type     Date
1      XXX-12345     Entry    22.03.2017 14:30
2      XXX-12345      Exit      22.03.2017 14:35

What I need from my data is a measure that calculates the time between an Entry and Exit date from particular LicencePlate.
I've done this with MSSQL but never in DAX, is this possible?
Comment
Watch Question

CERTIFIED EXPERT

Commented:
Hi,
you can do this easily using power query. which excel version you are using?
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
TracyVBA Developer
CERTIFIED EXPERT

Commented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.