---

VAR RequiredCourses =
    GENERATE(
        Personal,
        FILTER(
            ReqCourse,
            ReqCourse[Profile] = Personal[Profile]
        )
    )

VAR RequiredResult =
    GENERATE(
        RequiredCourses,
        VAR CurrentEmail = Personal[Email]
        VAR CurrentCourse = ReqCourse[Course]

        VAR TrainingRows =
            FILTER(
                Training,
                Training[Email] = CurrentEmail
                    &&
                Training[Course] = CurrentCourse
            )

        RETURN
            IF(
                COUNTROWS(TrainingRows) > 0,
                SELECTCOLUMNS(
                    TrainingRows,
                    "Date", Training[Date],
                    "Status", Training[Status]
                ),
                ROW(
                    "Date", BLANK(),
                    "Status", "Обязательный (не пройден)"
                )
            )
    )

VAR RequiredFinal =
    SELECTCOLUMNS(
        RequiredResult,
        "Email", Personal[Email],
        "Name", Personal[Name],
        "Course", ReqCourse[Course],
        "Date", [Date],
        "Status", [Status]
    )