Compare previous data and highlight the change

[Shameem]

Hello,

We have a requirement where I need to highlight the change in category.

I have Product, Plan , Time Period and Category fields . All fields are coming from different tables of data model.

Expected  to highlight ID:  3, 7 (as they have change in category)

ID	Product	Plan	Time Period	Category
1	Prod1	Plan1	2024-01	2
2	Prod1	Plan1	2024-02	2
3	Prod1	Plan1	2024-03	1
4	Prod1	Plan2	2024-01	2
5	Prod1	Plan2	2024-02	2
6	Prod2	Plan1	2024-01	1
7	Prod2	Plan1	2024-02	4

[Anonymous · Accepted solution]

Hi,@Shameem I am glad to help you.
Hello,@lbendlin ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.

Did you get your problem solved? If you don't have a suitable solution for your problem, you can refer to my suggestion.
By creating a measure and setting a conditional format based on the value of the measure.

M_Pro_plan_Changed02 = 
VAR CurrentCategory = MAX('Table'[Category])
VAR PreviousCategory = 
    CALCULATE(
        MAX('Table'[Category]),
        FILTER(
            ALL('Table'),
            'Table'[Product] = MAX('Table'[Product]) &&
            'Table'[Plan] = MAX('Table'[Plan]) &&
            'Table'[Time Period] < MAX('Table'[Time Period])
        )
    )
RETURN
IF(
    ISBLANK(PreviousCategory) || CurrentCategory = PreviousCategory,
    0,
    1
)

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

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

[lbendlin]

Do you want this done in Power Query, as a calculated column, a measure, or as a visual calculation?  What is your sort column? ID?

[Shameem]

Hello,  It can be as a calculated column, a measure, or as a visual calculation anything that is feasiable , 

The idea is to have the background colur of a column 'Access' highlighted in vizualization when the catogeroy is changed.