---

VAR RequiredWithTraining =
    SELECTCOLUMNS(
        FILTER(
            GENERATE(
                RequiredList,
                FILTER(
                    Training,
                    Training[Email] = [Email]
                        &&
                    Training[Course] = [Course]
                )
            ),
            TRUE()
        ),
        "Email", [Email],
        "Name", [Name],
        "Course", [Course],
        "Date", Training[Date],
        "Status", Training[Status]
    )

VAR RequiredWithoutTraining =
    SELECTCOLUMNS(
        FILTER(
            RequiredList,
            COUNTROWS(
                FILTER(
                    Training,
                    Training[Email] = [Email]
                        &&
                    Training[Course] = [Course]
                )
            ) = 0
        ),
        "Email", [Email],
        "Name", [Name],
        "Course", [Course],
        "Date", BLANK(),
        "Status", "Обязательный (не начат)"
    )