Avatar of gosi75
gosi75
Flag 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?
Microsoft Excel* DAX* PowerPivotMicrosoft Office

Avatar of undefined
Last Comment
Tracy

8/22/2022 - Mon
abbas abdulla

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

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Tracy

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Your help has saved me hundreds of hours of internet surfing.
fblack61