Extract url from text in DAX

[Ben_Nash]

Hi everyone

I'm trying to extract urls from twitter messages and placing in another column using DAX. I've been using this formula in excel to extract and it works fine:

=MID(A1,FIND("http",A1),IFERROR(FIND(" ",A1,FIND("http",A1))-1,LEN(A1))-FIND("http",A1)+1)

However I'm strugging to replicate/see how to do this in DAX. Any help greatly appreciated!

Thanks

Ben

[MattAllington]

I agree, you need to post an example. But I also think this is a task for data shaping in power query (get data) and not DAX. 

[Ben_Nash]

Hi

Thanks for getting back to me and good point on power query.

Screen grab of examples below - as you can see the urls aren't always in the same spot:

 Thanks 

Ben

[MattAllington]

How about using power query to split column on colon :  then rebuild the URL http:// from there

[Ben_Nash]

Hi Matt

Thanks for this - will do. Apologies for my ignorance but is there anyway I can bring across to power query the actual excel formula I have?

Regards

Ben

[MattAllington]

No way unfortunately. But using the power query UZi is much easier than writing Excel formulas. 

[Ben_Nash]

Thanks Matt - I'll give it a go in Power Query

Regards

Ben

[Baskar]

Hey Ben ,

Do u want like this ?

[Ben_Nash]

Hi

I'm giving the Power Query option a go but your screen shot look good - basically where ever there is a url it gets taken out and put in another column (s).

Thanks

Ben

[Ben_Nash · Accepted solution]

Hi Matt and Baskar - I've followed your suggestion Matt and sorted the problem starting from Query Editor>Transform>Split Column>By Delimiter>Custom>"https".

Thanks again!

Cheers

Ben

[Baskar]

Hey pls give an a example . like screen short what u have and what u excatly want ..

like this, This will help me to solve ur prob