Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Getting rid of NeuN value

I have a database coming from a .csv file. However, I am getting some cell values with "NeuN" after loading the csv file into Power Bi. These cells in original csv file have next value " NaN".   To...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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's avatar
calerof
Icon for Impactful Individual rankImpactful Individual
6 years ago

Hi Anonymous ,

 

You could try this. Go to Power Query, i.e. Transform Data, then select the column with NaN, change data type to Decimal Number, and then under the Transform ribbon, go to Replace Errors, and replace with 0. 

 

This way you'll get a clean numeric field.

 

Hope it helps.

 

Regards,

 

Fernando

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

why don't you simply remove those values.

 

Transform date -> select any column -> uncheck NEun Value ->Close and apply.

 

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.