topic Re: column and another column last letter comparison in DAX Commands and Tips

column and another column last letter comparison

Anonymous — Fri, 18 Nov 2022 12:41:02 GMT

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

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

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.

Re: column and another column last letter comparison

FreemanZ — Fri, 18 Nov 2022 12:56:16 GMT

Try to add a new column with the code below:

Result=

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

Re: column and another column last letter comparison

Anonymous — Mon, 21 Nov 2022 02:15:52 GMT

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.

Re: column and another column last letter comparison

Anonymous — Mon, 21 Nov 2022 06:35:27 GMT

Anonymous Thank you so much .