Forum Discussion
Getting rid of NeuN value
Anonymous Testing different things you suggest, leads me to the original csv. I added a new row and saved it again. Now, when loading into Power Bi, there is no problem at all to get rid off the NaN values. I can use "replace values" and It recognizes them perfectly. I presume there must be an error in the way csv file is built from original source. Thanks for your help!
What happens if you do not pull it in as a decimal but as a text? what does it show then?
Could you maybe share anonimized sample data for me to try somethings myself?
Anonymous Testing different things you suggest, leads me to the original csv. I added a new row and saved it again. Now, when loading into Power Bi, there is no problem at all to get rid off the NaN values. I can use "replace values" and It recognizes them perfectly. I presume there must be an error in the way csv file is built from original source. Thanks for your help!
calerof thanks for your help. As Anonymous suggest, I have marked my answer as a solution for this thread.
- calerof
Impactful Individual
Anonymous ,
1. Transform Data
2. Select column with errors, i.e. Column2
3. Add conditional column
4.
Glad i could help 😛
Please consider marking your reaction as a solution as i can be helpfull for others 🙂
Happy building! 😄
