Forum Discussion
Identify if string is made if of numeric values
Hi I am trying to identify on my report, using PowerQuery, if a purchadse order number; the column is declared as a text value, had/is all nuermic values. A number of Purchase orders numbers are...
One way to do it is to add a custom column with this formula, which will return True for number rows and False for ones with letters.
=Value.Is(Value.FromText([Column1]), type number)
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
One way to do it is to add a custom column with this formula, which will return True for number rows and False for ones with letters.
=Value.Is(Value.FromText([Column1]), type number)
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
PAt
So simple when you know how, that sgreta thanks.
Are you able to tell me the difference between 'type number' and 'Number.Type'
Chris