Forum Discussion

SarikaB's avatar
SarikaB
Regular Visitor
4 years ago
Solved

Split text and Date into different columns

Hello All,   I have a column with text as well as date I'm trying split the text and date into different columns   Please let me know how it can be achieved using DAX.   Thank you ...
DAX
Split column
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi SarikaB 

     

    You can create two seperate column with below code:-

     

    withDate = 

VAR firstLetter =
    LEFT ( Table[Date], 1 )
VAR numList = { "1", "2", "3", "4", "5", "6", "7", "8", "9", "0" }
RETURN
    IF ( firstLetter IN numList, Table[Date], BLANK () )

     

     

     

    withText = 
VAR firstLetter =
    LEFT ( Table[Date], 1 )
VAR numList = { "1", "2", "3", "4", "5", "6", "7", "8", "9", "0" }
RETURN
    IF ( NOT firstLetter IN numList, Table[Date], BLANK () )

     

     

    Output:-

     

    Thanks,

    Samarth

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi SarikaB 

 

You can create two seperate column with below code:-

 

withDate = 

VAR firstLetter =
    LEFT ( Table[Date], 1 )
VAR numList = { "1", "2", "3", "4", "5", "6", "7", "8", "9", "0" }
RETURN
    IF ( firstLetter IN numList, Table[Date], BLANK () )

 

 

 

withText = 
VAR firstLetter =
    LEFT ( Table[Date], 1 )
VAR numList = { "1", "2", "3", "4", "5", "6", "7", "8", "9", "0" }
RETURN
    IF ( NOT firstLetter IN numList, Table[Date], BLANK () )

 

 

Output:-

 

Thanks,

Samarth