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!
In the query editor you can select all column then press right mouse button and use replace values. Search for NeuN and replace with 0 or a space.
Anonymous I have already did that but it does nothing. NaN values are still there.
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
Impactful Individual
Anonymous ,
1. Transform Data
2. Select column with errors, i.e. Column2
3. Add conditional column
4.
