filter - Power BI - Get last month from last year

Question

I have this table:

Year	Month	Agency	Value
2019	9	1	233
2019	9	4	132
2019	8	3	342
2020	3	2	321
2020	3	4	34
2020	5	2	56
2020	5	4	221
2020	5	1	117
2018	12	2	112
2018	12	2	411
2020	4	3	241
2020	4	2	155

question from:https://stackoverflow.com/questions/66059016/power-bi-get-last-month-from-last-year

Answer 1

I solved it with this measure:

Measure =
VAR a =
    MAX ( 'Table'[Year] )
VAR b =
    MAX ( 'Table'[Months] )
VAR c =
    MAXX ( ALL ( 'Table' ), [Year] )
VAR d =
    MAXX ( FILTER ( ALL ( 'Table' ), [Year] = c ), [Months] )
RETURN
    IF ( a * 100 + b = c * 100 + d, 1, 0 )