cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pgarg Frequent Visitor
Frequent Visitor

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

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 nameRestriction for May'18Restriction for June'18Expected result
APAPANo Change
BQASTChange 
CSTPAChange
DPAST

Change

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
chethan Member
Member

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

@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

 

2 REPLIES 2
Super User
Super User

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

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

Highlighted
chethan Member
Member

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

@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