The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
248 | |
122 | |
110 | |
77 | |
70 |