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 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.
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 |
---|---|
97 | |
97 | |
82 | |
74 | |
66 |
User | Count |
---|---|
120 | |
105 | |
99 | |
81 | |
72 |