Max Column value based on another columns matching value

Jessica_17 

pls try this

Measure = 
VAR tbl=ADDCOLUMNS('Table',"check",if('Table'[AC]='Table'[CL]&&'Table'[AC]='Table'[CU],1,0))
return FORMAT(maxx(FILTER(tbl,[check]=1),'Table'[Months]),"mmmm")

pls try this

HI ryan_mayu 

Thanks It worked for me.

pls try this

Measure = 
VAR _tbl = TOPN(1,
 SELECTCOLUMNS(
        FILTER(
            ADDCOLUMNS(
           'Table',
                "Flag", INT( MIN( CALCULATE( MIN( 'Table'[AC] ) ), CALCULATE( MIN( 'Table'[CL] ) ) ) = CALCULATE( MIN( 'Table'[CU] ) ) )
            ),
            [Flag] = 1
        ),
        "@Month", 'Table'[Months],
        "@AC", 'Table'[AC]
    ),ABS([@AC]))
    RETURN 
    MAXX(_tbl,[@Month])