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.
Hi,
How to split digits if row has digit and text and if therer are no digit cell value should be same like below image
in image red value needs to like green value and non-digit value like non coloured value
Solved! Go to Solution.
Here is one way to do it. Add a custom column with this formula
= List.First(List.Select(Text.Split([location], "-"), each (try Number.FromText(_) otherwise 0) >0))
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Here is one way to do it. Add a custom column with this formula
= List.First(List.Select(Text.Split([location], "-"), each (try Number.FromText(_) otherwise 0) >0))
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |