Forum Discussion

Rune_'s avatar
Rune_
Frequent Visitor
6 years ago
Solved

Replace date if x value with other column date else keep date

I have a column (Lovet leveringsdato) where if no date has been input the default date is 01.01.1753. 

I want to replace all values containing 01.01.1753 with date from column (Levert dato), if other date then keep the date. 

 

I have tried with these formulas:

 

= Table.ReplaceValue(#"Egendefinert lagt til",each [Lovet leveringsdato], each if Date.From([Lovet Leveringsdato]) = #date(1753, 1, 1) then [Levert Dato] else [Lovet leveringsdato],Replacer.ReplaceValue,{"Lovet leveringsdato"})

 

and

 

= Table.ReplaceValue(#"Egendefinert lagt til",each Date.From([Lovet leveringsdato]), each if Date.From([Lovet Leveringsdato]) = #date(1753, 1, 1) then [Levert Dato] else [Lovet leveringsdato],Replacer.ReplaceValue,{"Lovet leveringsdato"})

 

Here are the columns

 

 

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Rune_ Why don't you try to add a conditional column like this.

     

     

     

    Hope this helps.

     

    Appreciate with kudos.

    Please mark as a solution if this solves the problem.

     

    Thanks