Link to home
Start Free TrialLog in
Avatar of gosi75
gosi75Flag for Iceland

asked on

DAX logic to calculate time between two rows

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?
Avatar of abbas abdulla
abbas abdulla
Flag of Bahrain image

Hi,
you can do this easily using power query. which excel version you are using?
ASKER CERTIFIED SOLUTION
Avatar of abbas abdulla
abbas abdulla
Flag of Bahrain image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.