Query Assistance: Personnel Numbers with Specific Course Conditions

[MarcDT21]

I have a query problem that I cannot solve myself and would be happy if someone could help me. But please no generic ChatGTP answers 😉 they don't help here...

I have two databases EmployeeListPersData and CoursesContinuing EducationAPPMAData which have a relationship in the model with the columns PersonnelNumber and IDMACourse.

Database 1: StaffListPersData
Database 1 column: PersonnelNumber

Database 2: CoursesContinuingEducationAPPMAData

Column Database 2: IDMACourse
Column database 2 :CourseType
Column database 2: Date

I would now like to see the personnel numbers in a table that meet the following conditions:
- Course type "Doctor's visit" is not in the database CoursesContinuing EducationAPMPA Data.
- Have course type "Doctor's visit" but the last recorded date (there can be more than one date recorded) + 720 days is less than today's date.

Thank you very much!

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...