Forum Discussion
Solved
Pulling numeric-only values from a alphanumeric field
I am trying to do analysis and summarization of a "numeric" field in one of our systems. The issue is, when bringing it into Power BI, Power BI recognizes it as alphanumeric (rightfully so) so I am u...
Yours is the simplest solution which can be done with just the interface. However, if I were to do a custom column, it would be
// Attempts to convert the value in [column] to a number and returns null if it fails try Number.From([column]) otherwise null
Hi,
Hope this helps.