Forum Discussion
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...
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!
Tahreem24
Super User
Super UserAnonymous ,
You can create calculated COlumn like below:
Column = IF(CONTAINSSTRING(Table[ColumnName],"NueN"),"",Table[ColumnName])
Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.