Forum Discussion

juhoneyighot's avatar
juhoneyighot
Helper III
2 years ago
Solved

Add a Custom Column

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_txtNC.IN
NC 110_Estimates__90CompleteNC
IN 610_CO EQ_Estimate__90CompleteIN
NC.IN 720_Dehu_Estimate__40Contract ExecutedNC.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

 

Tips and Tricks

2 Replies

  • Ahmedx's avatar
    Ahmedx
    Super User
    2 years ago

    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,"")))