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?
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
Last Comment
Tracy
ASKER CERTIFIED SOLUTION
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.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
you can do this easily using power query. which excel version you are using?