Replace null Special form

[SidsDataAnalyst]

Hi All

How can i replace only null value in 2nd column with the customer tye in 1st Column?

Please help me friends

[v-chenwuz-msft]

Hi @SidsDataAnalyst 

Can you try to change the code with null or “”via Advanced Editor as the following after you create a Conditional Column.

“”

Or

null

Or

“null”

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SidsDataAnalyst]

Thanks for your help but it didn't worked

I used this

[aj1973 · Accepted solution]

Hi @SidsDataAnalyst 

In Power Query add a conditional column