Returning an output within a time range
Hi, please help to write an appropriate DAX code. The issue: A transaction is a row that contains a Driver Number, Vehicle Number, Load Date and a Load Time. Upon checking the fact table, if a transaction for the same driver number, same load date, and load time in the time range of an hour (before or after the current load time) is found, then return the previous vehicle number, else return blank. Thanks!
