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]
)

     

     

eliasayyy's avatar
eliasayyy
Icon for Memorable Member rankMemorable Member
3 years ago
New Column =
IFERROR(
    LEFT(
        [Full Post Code], 
        SEARCH(" ", [Full Post Code], 1, LEN([Full Post Code])) - 1
    ), 
    [Full Post Code]
)