I have two sets of data -Data A and Data B. The data is a time range - Entry in and Exit.
I need to compare my two sets of data, within Power Bi to determine the following:
1. When a time, in Data A, falls between the entry and exit time in Data B
2. When a time range in Data A is missing from Data B
I have attached a screenshot of the data I am using.