Help to extract the date value from a series of texts.

[Anonymous]

Hello all,

I have a column "Reason for turn over" which values such as:

Termed on 10/21 due to attendance.

Termed on 10/23 due to Behavior.

and so on.

I need to find a calculated column to extract the date values(10/21 & 10/23) from the above values.

Thanks for your help!

[jdbuchanan71]

Hello @Anonymous 

You can use the query editor and make a copy of your column, split it by non-digit to digit then the next column by digit to non-digit then combine the two columns and delete the extras.

I have attached my sample .pbix for you to look at.

[Anonymous]

Thanks for your reply and it works.

I'm using Folder option under the Get data to import data into the report.

I'm looking to paste a new file in that folder and just Refresh the power bi report.

And each file has a reason column with date values.

Will your steps automatically separate the date values each time I paste a new file in that folder?

Thanks,

Anand

[jdbuchanan71 · Accepted solution]

Assuming the new file is the same format it will, yes.

[parry2k]

@Anonymous you can easily achieve this in Power Query using text between delimiters

 go to advanced editor and follow these instructions