Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

Query error editor

Hallo everybody,

I have some rows that contains some simple errors.

some colums have the number properties. in some of the rows are filled with -.

This creates an error. so i want to replace - with empty cell but cant replace it with the command replace values.

Because when i type - it will not except the input because its not a number.

What is the correct way to solve this kind of errors?

Tips and Tricks

v-yulgu-msft
7 years ago
Hi Anonymous,

Please change the data type of that field from "Any" to "Text" before replacing values. Then, you can replace "-" with "0" or empty. After replacing, you can change the data type to "Whole number".

Best regards,

Yuliana Gu

18 Replies

v-yulgu-msft
Microsoft Employee
7 years ago
Hi Anonymous,

Please change the data type of that field from "Any" to "Text" before replacing values. Then, you can replace "-" with "0" or empty. After replacing, you can change the data type to "Whole number".

Best regards,

Yuliana Gu
- Anonymous
  Not applicable
  7 years ago
  i solved it in the source tabel. thats not the way but the way you suggested didn't work for me.
  
  But everybody thanks for your patience with me.
  i will change the data in the source tabel in excel and refresh power bi table.
themistoklis
Community Champion
7 years ago
Why dont you replace '-' with zero as it is a number column?

Is it going to cause you any problems?
- Anonymous
  Not applicable
  7 years ago
  in the replace values command it will not accept '-' as a value to find and replace.
  it most be a number to find and replace.
  - PattemManohar
    Community Champion
    7 years ago
    Anonymous Tried the same and able to replace '-' with 0