Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.)
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |