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?
you can do this easily using power query. which excel version you are using?