Year to go Measure

Hi  TaroGulati ，

Try like below :

step1, create silcer table :

Table2 = DISTINCT('Table'[YYYYMM])

MON = RIGHT(Table2[YYYYMM],2)

year = LEFT(Table2[YYYYMM],4)

Step 2，create month and year column on base table:

Month = FORMAT('Table'[Date],"MM")

Year = FORMAT('Table'[Date],"YYYY")

 Then use the below measure :

NUMBER = 
VAR MON =
    CALCULATE (
        MAX ( 'Table2'[MON] ),
        FILTER ( ( 'Table2' ), MAX ( 'Table'[Month] ) > SELECTEDVALUE ( Table2[MON] ) )
    )
VAR YEAR =
    CALCULATE (
        MAX ( 'Table2'[year] ),
        FILTER ( ( 'Table2' ), MAX ( 'Table'[Year] ) = SELECTEDVALUE ( Table2[year] ) )
    )
RETURN
    IF ( MON <> BLANK () && YEAR <> BLANK (), MAX ( 'Table'[Numbers] ), BLANK () )

Get the below:

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien