cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Post Partisan

## column and another column last letter comparison

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.

1 ACCEPTED SOLUTION
Community Support

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.

3 REPLIES 3
Community Support

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.

Post Partisan

@v-yetao1-msft  Thank you so much .

Super User

Try to add a new column with the code below:

Result=

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

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors