Add a Custom Column

[juhoneyighot]

Hello!

Please help on how to add a custom Column for this condition. See table below.

I have a column stx_jobtype_txt then I want to get the NC.IN column which is I want it to be a custom column.

stx_jobtype_txt	NC.IN
NC 110_Estimates__90Complete	NC
IN 610_CO EQ_Estimate__90Complete	IN
NC.IN 720_Dehu_Estimate__40Contract Executed	NC.IN
012 Service_Service Call

Here are the conditions:

1st: if the first 5 characters is equal to "NC.IN" then NC.IN

2nd: if the first 3 characters is equal to "NC " then NC

3rd: if the first 3 characters is equal to "IN " then IN

else is blank

[Ahmedx · Accepted solution]

or try this

[Ahmedx]

pls try this

Measure = 
VAR Words = MAX('Table'[stx_jobtype_txt])
VAR IN_Word = MAX('Table'[NC.IN])
RETURN
IF( NOT ISBLANK(Words), 
 IF(
TRIM(
LEFT(Words,3))= IN_Word,IN_Word, if (TRIM(LEFT(Words,5))=IN_Word,IN_Word,"")))