How to apply conditional formatting for latest last years data in the matrix?

Hi  sekhar438 ,

Here are the steps you can follow：

1. Create calculated table.

True1 =
var _table1=
SUMMARIZE(
    'Table','Table'[customer],'Table'[Year],'Table'[Attribute],  "Value",SUMX(FILTER(ALL('Table'),'Table'[customer]=EARLIER('Table'[customer])&&'Table'[Year]=EARLIER('Table'[Year])&&'Table'[Attribute]=EARLIER('Table'[Attribute])),[Value]),
    "Rank",RANKX(FILTER(ALL('Table'),'Table'[customer]=EARLIER('Table'[customer])),[Year],,ASC,Dense))
var _table2=
FILTER(_table1,[Rank]<=2)
return
SUMMARIZE(
    _table2,[customer],[Attribute],[Year],[Value])

True2 =
VAR _table1 =
    SUMMARIZE (
        'True1',
        'True1'[customer],
        'True1'[Attribute],
        "Year", "Status",
        "Value",
            IF (
                SUMX (
                    FILTER (
                        ALL ( True1 ),
                        'True1'[customer] = EARLIER ( 'True1'[customer] )
                            && 'True1'[Attribute] = EARLIER ( 'True1'[Attribute] )
                            && 'True1'[Year]
                                = MINX (
                                    FILTER (
                                        'True1',
                                        'True1'[customer] = EARLIER ( 'True1'[customer] )
                                            && 'True1'[Attribute] = EARLIER ( 'True1'[Attribute] )
                                    ),
                                    [Year]
                                )
                    ),
                    [Value]
                )
                    <= SUMX (
                        FILTER (
                            ALL ( True1 ),
                            'True1'[customer] = EARLIER ( 'True1'[customer] )
                                && 'True1'[Attribute] = EARLIER ( 'True1'[Attribute] )
                                && 'True1'[Year]
                                    = MAXX (
                                        FILTER (
                                            'True1',
                                            'True1'[customer] = EARLIER ( 'True1'[customer] )
                                                && 'True1'[Attribute] = EARLIER ( 'True1'[Attribute] )
                                        ),
                                        [Year]
                                    )
                        ),
                        [Value]
                    ),
                UNICHAR ( 9650 ),
                UNICHAR ( 128315 )
            )
    )
RETURN
    UNION ( 'True1', _table1 )

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly