Forum Discussion
Clean data to only Integers
hi, Anonymous
If you want to Conversion values like "Five" to integers, you need a conversion table like this:
then do these as below:
step1:
use this formula to add a column
try Number.From([Column1]) otherwise 0
Step2:
merge basic table with conversion table
expand the table
Step3:
add a conditional column
Result:
here is pbix, please try it.
https://www.dropbox.com/s/hy5kcg8b1sgidnb/Clean%20data%20to%20only%20Integers.pbix?dl=0
Best Regards,
Lin
Wait... so you have some field with value like "Five" and need that converted to 5?
Hmm, can't think of way to do this, except with separate conversion table.
Correct, I was hoping for a function to do it, but doesn't look like such exists. Coversion table it is!
hi, Anonymous
If you want to Conversion values like "Five" to integers, you need a conversion table like this:
then do these as below:
step1:
use this formula to add a column
try Number.From([Column1]) otherwise 0
Step2:
merge basic table with conversion table
expand the table
Step3:
add a conditional column
Result:
here is pbix, please try it.
https://www.dropbox.com/s/hy5kcg8b1sgidnb/Clean%20data%20to%20only%20Integers.pbix?dl=0
Best Regards,
Lin
Thank you for the very comprehensive answer