DAX equivalent for nested SQL query

[MatiasAraya]

Hello:

I'm trying to express this query into DAX, because using SQL queries is not posible in the current env I'm working on.

select ID, MAX(YEAR), NAME, SPECIALIZATION

    from STUDENTS_TABLE A

    where not exists 

    ( select distinct B.YEAR, B.ID

        from STUDENTS_TABLE B

        where B.YEAR in (A.YEAR - 1,A.YEAR - 2) and A.ID=B.ID

    )

    order by A.ID ,A.YEAR

    group by (A.ID);

Any help would be appreciated

[ThxAlot]

Which sql dialect do you use? It seems the syntax is wrong ...

select ID
	, MAX(YEAR) as max_yr
	, NAME
	, SPECIALIZATION
from STUDENTS_TABLE A
where not exists 
	( select NULL
		from STUDENTS_TABLE B
		where B.YEAR in (A.YEAR - 1,A.YEAR - 2) and A.ID=B.ID
	)
group by A.ID, A.NAME, A.SPECIALIZATION

Table =
SUMMARIZECOLUMNS(
    STUDENTS_TABLE[ID], STUDENTS_TABLE[NAME], STUDENTS_TABLE[SPECIALIZATION],
    "max_yr",
    MAXX(
        FILTER(
            VALUES( STUDENTS_TABLE[Year] ),
            VAR __yr = STUDENTS_TABLE[Year]
            RETURN
                ISEMPTY(
                    FILTER(
                        VALUES( STUDENTS_TABLE[Year] ),
                        STUDENTS_TABLE[Year] IN { __yr - 1, __yr - 2 }
                    )
                )
        ),
        STUDENTS_TABLE[Year]
    )
)