Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |