Concatenate result if condition is met

[Borjaveigasvh]

Good Morning to all,

I am trying to create a conditional column, when one of the columns is null, I would like to create a value in each row that is the concatenated of an other column & 00000

else I would like the column to be as the initial

I wrote it like this :

= Table.AddColumn(#"Duplicados quitados", "CUSEC2", each if [CUSEC] = " " then Text.PadEnd([CM_FISCAL],9,"0")else [CUSEC])

But the result got eas not as I expected, I' obtaining exactly the value that appears at [CUSEC] but the nulls keep being nulls

Would Appreciate any help with t

[Smauro · Accepted solution]

Hi @Borjaveigasvh

By [CUSEC] = " " you're not checking for nulls though, you should use [CUSEC] = null. Also, if [CM_FISCAL] is null then Text.PadEnd will result in null as well