Excel Power Query Replace error in one column with values from another column

Hi wonderful community, I have an Excel table that I loaded to Power Query and I can't figure out how to replace Error values with the value in another column (See snapshot). Does...

Replace Error with respective value from another column.xlsx180 KB

BI & Data Analysis

excel

Formulas and Functions

SergeiBaklan

Aug 31, 2022

afzalbaharudin

As variant

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(
        Source,
        {{"Day", type date}, {"Earl.start", type date}}),
    #"Replaced Value" = Table.ReplaceValue(
        Table.ReplaceErrorValues(#"Changed Type", {{"Day", null }}),
        null,
        each _[Earl.start],
        Replacer.ReplaceValue,{"Day"}),
    DayToDate = Table.TransformColumnTypes(
        #"Replaced Value",{{"Day", type date}})
in
    DayToDate

Replace Error with respective value from another column.xlsx186 KB

let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Table.TransformColumnTypes( Source, {{"Day", type date}, {"Earl.start", type date}}), #"Replaced Value" = Table.ReplaceValue( Table.ReplaceErrorValues(#"Changed Type", {{"Day", null }}), null, each _[Earl.start], Replacer.ReplaceValue,{"Day"}), DayToDate = Table.TransformColumnTypes( #"Replaced Value",{{"Day", type date}}) in DayToDate

Forum Discussion

Excel Power Query Replace error in one column with values from another column

Resources