Power Query: replace value less than

[kman42]

I need to replace the value of a column if the original value is less than a certain date. I have it working with a discreet date, but how do I modify the following to make it work for any date less than 1970-01-01?

#"Replaced Value" = Table.ReplaceValue(#"Expanded project","1962-01-01",null,Replacer.ReplaceValue,{"award_notice_date"}),

Thanks!

[alena2k · Accepted solution]

I would add conditional column:
= Table.AddColumn(#"Expanded project", "Replaced Award Date", each if [award_notice_date] < #date(1970, 1, 1) then null else [award_notice_date])

[v-xuding-msft · Accepted solution]

Hi @kman42 ,

Have you resolved the problem? If not, please try like this:

= Table.ReplaceValue(#"Expanded project",#date(1962, 1, 1),null,Replacer.ReplaceValue,{"Date"})

[alena2k · Accepted solution]

I would add conditional column:
= Table.AddColumn(#"Expanded project", "Replaced Award Date", each if [award_notice_date] < #date(1970, 1, 1) then null else [award_notice_date])