Compare text columns in two different tables over a time period and identify the differnces

[pgarg]

I have a fixed column named "Plan"and I want to compare its Restriction over 2 months and flag the rows which changed.

To make the question more clear,  below are the details. Can someone please help ?

Plan name	Restriction for May'18	Restriction for June'18	Expected result
A	PA	PA	No Change
B	QA	ST	Change
C	ST	PA	Change
D	PA	ST	Change

[chethan · Accepted solution]

@pgarg

Use below DAX, before that Please create the Relation between both the Tables the Create the Calculated Column

Expected Results =
IF (
    'Sales Data'[Customer Name Index] = RELATED ( 'Customer Data'[Customer Index] ),
    "No Change",
    "Change"
)

Regards,

Chetan K

[rajendran]

For this sample data, you can create a calculated column with the below formula.

COmparision=IF(Table1[Restriction for May'18]=Table1[Restriction for June'18], "No Change", "Change")

Thanks

Raj