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 All,
I have the following REPLACE function , which works fine, but my column has different values, for example the other value is "Bagels for Life", how can i change both or more values using REPLACE? Please advice.
DEFINE
VAR Val = "Donuts for Life"
VAR Replacement = "DFL"
EVALUATE
{
( "Original", Val ),
( "Replaced", REPLACE ( Val, 1, 15, Replacement ) )
}
Thanks
Solved! Go to Solution.
Hi @Anonymous
You can create a custom column as:
Text.Select([Column1],{"A","B","C","D","E","F","L"})
You need to add all relevant capital letters in the red underlined part, you can also just add 'A-Z'.
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Hi @Anonymous
You can create a custom column as:
Text.Select([Column1],{"A","B","C","D","E","F","L"})
You need to add all relevant capital letters in the red underlined part, you can also just add 'A-Z'.
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
hi @Anonymous
Are the values such as "Donuts for Life" par of a larger string "Donuts for Life is Good"? If Not, then can we add custom column in power query and replace the values?
Thanks,
alekh
Any idea if i can replace multiple values in a column? Please.
Thanks
@Anonymous , You want replace or substitute ?
https://docs.microsoft.com/en-us/dax/substitute-function-dax
@amitchandak thanks , all i want is where ever in my column is see values "Donuts for Life", "Bagels for Life" , "Fries for Life", need to see DFL,BFL,FLF respectively. I do not know if using REPLACE or SUBSTITUTE is good.
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |