column and another column last letter comparison

[Anonymous]

I have two column In the table first column name ID  and next column name pd-id .  I am trying to compare First column  value and Next column last num  if match  both value match its return  True  and both value not match its  return False

Example :

ID         Pd-id 

1          ID01-PS-001

 1         ID01-PS-001

 2         ID01-PS-001

 1          ID01-PS-002

 3         ID01-PS-003

  2         ID01-PS-002

  3          ID01-PS-002

  4          ID01-PS-004

Expected output:

ID         Pd-id                        Result 

1          ID01-PS-001             True 

 1         ID01-PS-001             True

 2         ID01-PS-001             False

 1          ID01-PS-002             False

 3         ID01-PS-003              True

  2         ID01-PS-002             True

  3          ID01-PS-002            False

  4          ID01-PS-004            True

I am looking for support . thanks in advance.

[Anonymous · Accepted solution]

Hi @Anonymous 

First , you need to extract the last num in your Pd-id column . Create a calculated column :

Column = RIGHT('Table'[Pd-id],1)

Change data type of the column to whole number .

Then create a calculated column to compare the First column  value and Next column last num .

Result = IF('Table'[Column]='Table'[ID],TRUE,false)

You will get a result like this :

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@Anonymous  Thank you so much . 

[FreemanZ]

Try to add a new column with the code below:

Result=

IF(CONTAINSSTRING([id], [pd-id]), TRUE, FALSE)