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.
I have about a dozen columns with lots of rows all with various numbers in them as well as other non-numerical data. I would like to use Power Query to replace all of those number values with "$$$" and keep all of the other text values. Is there an easy way to do this?
When I try to use the Replace Values functionality it only lets be pick specific numbers, but I need any number to be changed.
Thanks for any help!
Solved! Go to Solution.
NewStep=Table.ReplaceValue(PreviousStepName,"","",(x,y,z)=>Text.Combine(Text.SplitAny(Text.From(x),"0123456789"),"$"),Table.ColumnNames(PreviousStepName))
NewStep=Table.ReplaceValue(PreviousStepName,"","",(x,y,z)=>Text.Combine(Text.SplitAny(Text.From(x),"0123456789"),"$"),Table.ColumnNames(PreviousStepName))
Thanks for the help! I'm still learning, do you think you could add a bit of an explainer?
Hi @Bibendum ,
Add a new step in the applied steps.
Enter the formula @wdx223_Daniel provided, modify it.
Then press enter to confirm.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |