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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III
Helper III

Help with formula

Hi All,


I need some help in removing -UK from both columns Source Code and Allocation

and also everything was is after / in the Source Code




Any help please?



Super User
Super User



you can do this in power query, just right click the columns, select replace values type -uk in the first and leave the second blank

@DOLEARY85  I can't, wont let me if I'm querrieng the data from the database. To use Power Query I need to import the data and will take ages.



Ah okay, 


for the -uk part you could create a column in report view:


Column = SUBSTITUTE('Table (2)'[Column1],"-uk","")

For the part after the /  you could use the search function to count the starting character using wildcards in the search e.g 

SEARCH("???-uk",'Table (2)'[Source Code], 1, 0)
then use a Left function to get the left value of the string up to 1 character before the start:
full column: 
left('Table (2)'[Source Code],SEARCH("???-uk",'Table (2)'[Source Code], 1, 0)-1 )

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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