08-16-2016 10:08 PM
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:
However I'm strugging to replicate/see how to do this in DAX. Any help greatly appreciated!
Solved! Go to Solution.
08-22-2016 05:08 AM
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".
08-17-2016 12:12 AM
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.
08-17-2016 01:00 AM
How about using power query to split column on colon : then rebuild the URL http:// from there
08-17-2016 02:27 AM
No way unfortunately. But using the power query UZi is much easier than writing Excel formulas.