Hi! I have some data like the following:
I need to work with just the numbers in the column. How can I delete the text data without removing the whole row? A new column like the following would be ideal, but it returns "" in every row (I suspect it is testing if the whole column is numbers).
Just% = IF(ISNUMBER([%]), [%], "")
if Value.Is([%], Int64.Type) then [%] else ""