DAX logic to calculate time between two rows

gosi75
gosi75 used Ask the Experts™
on
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
abbas abdulla

Commented:
Hi,
you can do this easily using power query. which excel version you are using?
Commented:
Hi,
Check the attached file
Time-Diff-PQ.xlsx
TracyVBA Developer

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial