Update column with PQuery

[gparrin71]

Hi,

How can I update,with powerquery, the first column of the attached photo with the data of the second if the value is different?

Tnks a lot

Gianni

[gparrin71]

Hi,

The function you suggested gives me the same problem I had with a function I had already tried. The status "ORDERED" does not change to "DELIVERED"

Tanks

Gianni

[bcdobbs]

Can you send a demo pbix file? Think i'm

missing something about your specification.

[gparrin71]

Thanks to the immediate response.
Yes, they are already in a table.
I'm just starting out with custom columns. Can you tell me how to do it?

[bcdobbs]

No problem.

I started with a demo table like this:

Then clicked Add Column >> Custom Column

Syntax I used was:

if [New Column A] = "" 
then [Original Column A]
else [New Column A]

(Note that if, then and else have to be lower case in Power Query M )

Results in:

[bcdobbs]

Depending on your source you might have nulls instead of empty text so the following is more hardened:

if [New Column A] = "" or [New Column A] = null
then [Original Column A]
else [New Column A]

[bcdobbs · Accepted solution]

Are the columns already in one table?

If not merge the two tables in power query on a common set of columns.

You can then create custom columns with if statements that take the 2nd value unless it's null in which case use the 1st.

Finally remove the old columns and renames the new ones correctly.