Forum Discussion

cyborgandy's avatar
cyborgandy
Icon for Helper II rankHelper II
3 years ago
Solved

Split Column DAX Before Space

Hi All,   I have below column in my dataset, I want to use delimiter DAX to give me all the left value result before the space however I have written a dax but as I have few entries which doesnt ha...
  • eliasayyy's avatar
    eliasayyy
    3 years ago
    New Column =
IFERROR(
    LEFT(
        [Full Post Code], 
        SEARCH(" ", [Full Post Code], 1, LEN([Full Post Code])) - 1
    ), 
    [Full Post Code]
)

     

     

mlsx4's avatar
mlsx4
Icon for Memorable Member rankMemorable Member
3 years ago

Hi cyborgandy 

 

Try this code... Otherwise, you will miss some values when there's no space

 

 

New Column = 

IF(CONTAINSSTRING([Full post code]," "),
    LEFT(
        [Full Post Code], 
        SEARCH(" ", [Full Post Code], 1, LEN([Full Post Code])) - 1
),
[Full post code]
)

 

 

Kind regards