cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AnandAmirtharaj Frequent Visitor
Frequent Visitor

Replace dynamic values in Query editor

Hi Everybody,

 

In Column A i need to Find and Replace dynamic values:

 

Example: Its always # and additional 2 numeric values like #23. This numeric 23 will keep changing dynamically picking up from database. Please help me how do i find and replace this # and two numeric characters always?

 

Thank you in advance

 

Regards,

Anand

2 REPLIES 2
Moderator v-caliao-msft
Moderator

Re: Replace dynamic values in Query editor

Hi @AnandAmirtharaj,

 

What's your expected result?

 

In DAX, REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string.
https://msdn.microsoft.com/en-us/library/ee634374.aspx

 

Please provide us more information, so that we can make further analysis.

 

Regards,

Charlie Liao

Highlighted
AnandAmirtharaj Frequent Visitor
Frequent Visitor

Re: Replace dynamic values in Query editor

Hi v-caliao-msft,

 

The field will always contain example as below

 

Actual field (single column): www.abc.com@EmployeeID1#11;#www.abc.com@EmployeeID2#32;#www.abc.com@EmployeeID3....

 

Expected Result field (single column): EmployeeID1, EmployeeID2.... and so on

 

Here is the above scenario i always wanted to extract only Employee ID i.e. the field to say EmployeeID1, Employee2 and so on. But the challenge is (refereing above example) the numbers 11 and 32 and so on.... could be any number that will change dynamically

 

Please help !

 

Regards,

Anand

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 134 members 1,623 guests
Please welcome our newest community members: