How to reference differences between columns of visualization

Hi Anonymous ,

According to your description, I create a sample, you can create a measure like this:

Measure =
VAR _Pre =
    MAXX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[Company_Name] = MAX ( 'Table'[Company_Name] )
                && YEAR ( 'Table'[Date] ) = YEAR ( MAX ( 'Table'[Date] ) )
                && MONTH ( 'Table'[Date] )
                    = MONTH ( MAX ( 'Table'[Date] ) ) - 1
        ),
        'Table'[Invoice]
    )
RETURN
    IF (
        _Pre <> BLANK ()
            && DIVIDE ( MAX ( 'Table'[Invoice] ) - _Pre, MAX ( 'Table'[Invoice] ) ) > 0.03,
        "RED"
    )

In the visual formatting pane>Cell elements, turn on the Font color, apply the measure to the Invoice color.

Get the 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.