How to track changes (text fields) on rows compared to next month?

Hi Anonymous ,

According to your description, here’s my solution.

1.Create a measure to check the status.

Check =
IF (
    CALCULATE (
        COUNTROWS ( 'october' ) = 0,
        FILTER ( ALL ( 'october' ), 'october'[article] = MAX ( 'november'[article] ))
    ),
    "New",
    IF (
        CALCULATE (
            COUNTROWS ( 'november' ) = 0,
            FILTER (
                ALL ( 'november' ),
                'november'[article] = MAX ( 'october'[article] )
                    && 'november'[AO] = MAX ( 'october'[AO] )
                    && 'november'[BO] = MAX ( 'october'[BO] )
                    && 'november'[DESCRIPTION] = MAX ( 'november'[DESCRIPTION] )
                    && 'november'[RELATION] = MAX ( 'october'[RELATION] )
            )
        ),
        "Change",
        BLANK ()
    )

)

2.Create color measures for conditional formatting.

ColorAO = IF('november'[Check]="Change",IF(MAX('november'[AO])<>MAX('october'[AO]),"Red"))

ColorBO = IF('november'[Check]="Change",IF(MAX('november'[BO])<>MAX('october'[BO]),"Red"))

ColorDES = IF('november'[Check]="Change",IF(MAX('november'[DESCRIPTION])<>MAX('october'[DESCRIPTION]),"Red"))

ColorREL = IF('november'[Check]="Change",IF(MAX('november'[RELATION])<>MAX('october'[RELATION]),"Red"))

3.Select Conditional formatting and turn on Font color, for each column, select the corresponding color measure.

For column AO:

4.Get the expected result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

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