Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
CiaraCaryl
Frequent Visitor

Help with formatting websites to one format instead of 5-6 formats

I have a column with a bunch of website links that are all formatted differently so extract and split column aren't working as it just removes all other websites that don't follow that format.

I have websites starting with:
https://www. or  http:// or  www.  and some with no beginning to the link. Then some of the web links end with a / after the .com

I'm wanting all websites to be formatted as domains so it would just be: websitename.com

I'm not sure how to do this with a conditional column, custom column, calculated column or what. If I use split or extract it just messes everything up and makes things even more different. Any ideas? Please see reference picture to see what I'm working with.

CiaraCaryl_0-1746720260512.png

1 ACCEPTED SOLUTION
CiaraCaryl
Frequent Visitor

I found my own solution by splitting the column by deliminators multiple times to get the part of the weblink I needed then merged the columns with the resulting format I was looking for. If you know of an easier way let me know but this worked.

View solution in original post

1 REPLY 1
CiaraCaryl
Frequent Visitor

I found my own solution by splitting the column by deliminators multiple times to get the part of the weblink I needed then merged the columns with the resulting format I was looking for. If you know of an easier way let me know but this worked.

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.