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?
