Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I need to search and replace any letters in a column (could be aA-zZ) with a number or if the row contains only a number to leave the number. How can I use a wildcard or something else to convert any field with any letter character and replace with zero? These are calculated columns so I can't make this change in power query.
Example rows
Column A | New Column |
1500 | 1500 |
mno | 0 |
2000 | 2000 |
abc | 0 |
dfg | 0 |
350 | 350 |
qrs | 0 |
900 | 900 |
Solved! Go to Solution.
Was that stated in the original post or have you edited it? If so, I apologise.
In DAX, you can use an IFERROR to assign a different value,
so can you add a new column, CONVERT to integer and assign 0 if it throws an error.
I'll let you get on with that.
Hope this helps:
Was that stated in the original post or have you edited it? If so, I apologise.
In DAX, you can use an IFERROR to assign a different value,
so can you add a new column, CONVERT to integer and assign 0 if it throws an error.
I'll let you get on with that.
In Power Query, change the datatype to number.
Then replace Errors with 0.
You can do this from the interface.
I can't do it in power query. Its a calculated column outside of power query.
User | Count |
---|---|
94 | |
79 | |
73 | |
63 | |
60 |
User | Count |
---|---|
108 | |
100 | |
77 | |
63 | |
61 |