Solved: Error while converting to numeric

badluckmath · ‎09-22-2020

So, i'm trying to convert some Data to numeric of Clicks, impressions, etc on ADS.

When i do this, the N/A rows are converted into Error and you can see below:

Here, you can see a converted column (Impressions) and a must-be-coverted Columns ( Clicks,etc.)

AnkitKukreja · ‎09-22-2020

This is giving error because of obvious reason i.e. NA cannot be converted to number.
As a best practice I convert NA to '0' before converting it to numeric format or I give it a random number '9999' to identify these later on in your analysis.

Thanks,
Ankit Kukreja

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

View solution in original post

AnkitKukreja · ‎09-22-2020

Hi @badluckmath

This is giving error because of obvious reason i.e. NA cannot be converted to number.
As a best practice I convert NA to '0' before converting it to numeric format or I give it a random number '9999' to identify these later on in your analysis.

Thanks,
Ankit Kukreja

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904