Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
Solved! Go to 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
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.
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
How about using power query to split column on colon : then rebuild the URL http:// from there
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
No way unfortunately. But using the power query UZi is much easier than writing Excel formulas.
Thanks Matt - I'll give it a go in Power Query
Regards
Ben
Hey Ben ,
Do u want like this ?
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
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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
79 | |
64 | |
52 | |
47 |
User | Count |
---|---|
217 | |
89 | |
76 | |
67 | |
60 |