Iterate automatically trough columns (conditional formatting on matrix table)

Hi ferk_23 ,

I created a sample pbix file(see the attachment), please check if that is what you want.

1. Unpivot these date fields in Power Query Editor

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCk5MSy2pVNJRcgRiQxDWg5DGSrE6SNJOQGygZw4mLcGkBVhBeH5RtoJHfmlRMdQMmLQJ1CwMRU5wSwyAlkBNigUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"KPI Name" = _t, Version = _t, #"Oct-23" = _t, #"Nov-23" = _t, #"Dec-23" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Oct-23", type number}, {"Nov-23", type number}, {"Dec-23", type number}}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"KPI Name", "Version"}, "Date", "Value"),
    #"Changed Type1" = Table.TransformColumnTypes(#"Unpivoted Columns",{{"Date", type date}})
in
    #"Changed Type1"

2. Update the formula of measure [color] as below

color = 
VAR _curyear =
    YEAR ( TODAY () )
VAR _curmonth =
    MONTH ( TODAY () )
VAR _date =
    DATE ( _curyear, _curmonth, 1 ) - 1
VAR _seldate =
    SELECTEDVALUE ( 'Table'[Date] )
VAR _kpi =
    SELECTEDVALUE ( 'Table'[KPI Name] )
VAR _a =
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[KPI Name] = _kpi
                && YEAR ( 'Table'[Date] ) = YEAR ( _date )
                && MONTH ( 'Table'[Date] ) = MONTH ( _date )
                && 'Table'[Version] = "A"
        )
    )
VAR _b =
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[KPI Name] = _kpi
                && YEAR ( 'Table'[Date] ) = YEAR ( _date )
                && MONTH ( 'Table'[Date] ) = MONTH ( _date )
                && 'Table'[Version] = "B"
        )
    )
RETURN
    IF (
        YEAR ( _seldate ) = YEAR ( _date )
            && MONTH ( _seldate ) = MONTH ( _date ),
        IF ( _a >= _b, "#1AAB40", "#D64554" )
    )

Best Regards