removing empty fields in a column

[Anonymous]

when i remove empty fields in power query editor i get an error at the top how can i fix that? 

[1Daniel993]

Ok, try not remove the blanks and null, just filter it in the columns. (blanks and nulls don't appear in power bi)

[Anonymous]

oh wow didnt know that thanks. what should i filter it by?

[1Daniel993]

Because maybe you cell (ERROR) depend for some value, so when you filter don't desapear the value and the cell working

[Anonymous]

okay i will try that thanks

[1Daniel993]

Hello, how is the code for that column? 

[Anonymous]

what do u mean by code? i imported an excel file into power bi. then i hit transform data to make changes  and remove nulls and blanks and columns.