Split text and Date into different columns

[SarikaB]

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

[Samarth_18 · Accepted solution]

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