I have a complex data model with 2 fact tables (AuditCalls and Exams) and both have ActiveDate for time selection..
How do I get the AgentName from the ExamsBookedDateTime to link to the AgentName in the AuditCallsAgentsNEW2 table? When I tried I was getting Looping errors. Here's screenshot of data model.