cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## 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.

Regards,

Sarika

1 ACCEPTED SOLUTION
Community Champion

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

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Community Champion

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

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.