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 in advance.

 

Regards,

Sarika

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

1 Reply

  • 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