Getting rid of "null" results

[Anonymous]

Goodevening everyone,

I have an issue with a "NULL" notification.

The whole day i am looking for a solution, but can't find the wright one, which will works on mine.

With a query i become data out of our system.

One of the given data becomes in the column "OptioneleOnderdelen"

In some cells i have the correct information i will need, in others "NULL" and in other cells the one is empty.

But when i will use this table for a new custom column, the solution is everywhere fine, except the ones with the result "NULL".

This results in an "Error".

Does someone knows how i can change the type "NULL" to an empty cell, when the column has no data filled ?

My last try was in in the Advanced Editor by placing the code:

#"Changed Type 5" = Table.ReplaceValue(#"Changed Type",each[OptioneleOnderdelen],each if [OptioneleOnderdelen]=null then 0 else 0 ,Replacer.ReplaceValue,[Optionele Onderdelen])

Unfortunatly without result.

Greets, 

Alfons

[rsbin]

@Anonymous ,

Try changing your code to this:

= Table.ReplaceValue(#"ChangedType",null,"",Replacer.ReplaceValue,{OptioneleOnderdelen})
//You can replace the "" with 0 if you prefer.

Hope this works for you.

Regards,

[Anonymous]

Hello rsbin,

THank you for the fast response.

I have filled your text in, in the "Advanced Editor".

But this does not work.

I am wondering if i am putting this in the wright way on the wright place.

[rsbin · Accepted solution]

@Anonymous,

best to let Power Query build the code for you.  Delete the last step you highlighted. Then add a new step as follows:

1) Right click on your column Optioel....

2) Select the Replace Values option in the dropdown.

Type in null and then leave blank or put in 0...whatever you prefer.

[Anonymous]

Perfect!

So simple! My errors are gone.

My weekend starts good again.

Thank you!

Enjoy your weekend!

[rsbin]

@Anonymous ,

Glad it worked for ya.  Enjoy your weekend as well!