Forum Discussion

juhoneyighot's avatar
juhoneyighot
Icon for Helper III rankHelper III
2 years ago
Solved

Get the characters from a text using DAX

Hello! I need help to get the characters from a certain text using DAX. I have this Column "JobType". See table below. Jobtype NC.IN Phase Status NC 120_Rough Builder Walk__10Not Started ...
DAX Commands and Tips
  • Subash_Govind's avatar
    Subash_Govind
    2 years ago

    Hi juhoneyighot ,

     

    Below are DAX codes for creating new column,

    Phase =
    VAR BEFORE_DELIMITER = LEFT('DAX Custom column'[Job Type],(SEARCH("__",'DAX Custom column'[Job Type]))-1)
    RETURN IF('DAX Custom column'[NC.IN] = BLANK()," ",BEFORE_DELIMITER)
    Status =
    VAR AFTER_DELIMITER = RIGHT('DAX Custom column'[Job Type],(LEN('DAX Custom column'[Job Type])-SEARCH("__",'DAX Custom column'[Job Type]))-1)
    RETURN IF('DAX Custom column'[NC.IN] = BLANK(),BLANK(),AFTER_DELIMITER)
     
    It worked as below...
Subash_Govind's avatar
Subash_Govind
Frequent Visitor
2 years ago

Hi juhoneyighot ,

 

Below are DAX codes for creating new column,

Phase =
VAR BEFORE_DELIMITER = LEFT('DAX Custom column'[Job Type],(SEARCH("__",'DAX Custom column'[Job Type]))-1)
RETURN IF('DAX Custom column'[NC.IN] = BLANK()," ",BEFORE_DELIMITER)
Status =
VAR AFTER_DELIMITER = RIGHT('DAX Custom column'[Job Type],(LEN('DAX Custom column'[Job Type])-SEARCH("__",'DAX Custom column'[Job Type]))-1)
RETURN IF('DAX Custom column'[NC.IN] = BLANK(),BLANK(),AFTER_DELIMITER)
 
It worked as below...