Skip to main content
cancel
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

Reply
adoalan
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

 

adoalan_0-1680603330732.png

 

Any help please?

 

Thanks

4 REPLIES 4
DOLEARY85
Super User
Super User

Hi,

 

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

Announcements
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.