Forum Discussion
Query Assistance: Personnel Numbers with Specific Course Conditions
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!
1 Reply
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-Forum/ba-p/963216
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/1447523
