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.
Hello,
I am trying to create a custom column with the following results, using Power Query -
10.01.01 | Code |
40.02.01.01 | Code |
20.001.20.0001 | Code |
ABC.DEF.GHI | Not Code |
ABD DEF | Not Code |
01.ABC | Not Code |
null | Not Code |
Appreciate any assistance here!
I am still looking for assistance, so will really appreciate any advice here.
Thanks!
Thanks for reaching out to us.
One idea, you have to create a column to determine whether the column contains letters, and then filter the custom column.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hello v-xiaotang,
I have limited knowledge of M, so am requesting assistance with "creating a column to determine if the column contains letters".
I tried to customize this code that I found online but got the error - "cannot convert the value to type Logical."
if Text.SplitAny(Text.Lower([Name]),"abcdefghijklmnopqrstuvwxyz"){0} then "Remove" else null
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |