Replace null values with values from several other columns

[Anonymous]

Hi,

I imported a .csv file into Power BI and due to some of the column headers having different cases, multiple columns were created where there should only be one. I need to combine those columns back into one:

tag_user_ItemID and tag_user_ItemId.1 both have itemID values that I need to add to the tag_user_itemid.2 column. So, if tag_user_itemid.2 has a null value, check to see if tag_user_ItemId.1 has a value and if it does, add it to tag_user_itemid.2. If not, check tag_user_ItemID and do the same. Otherwise leave null.

[parry2k · Accepted solution]

@Anonymous add new custom column in Power Query using following expression

= if [tag_user_Itemid.2] <> null then [tag_user_itemid.2] else
if [tag_user_Itemid.1] <> null then [tag_user_Itemid.1] else
[tag_user.ItemID]
end