How to replace the text with last week date in Power Query

[naoyixue1]

Hey! I'm now trying to replace the text with last week date in power query, but failed. (see below exact changes I made)

Any thoughts? Thanks!

That's what I originally used to replace the text with today date. 

Date.ToText(Date.From(DateTime.LocalNow()))

Here is what I tried to replace with last week date, but failed 

Date.AddDays(Date.From(DateTime.LocalNow())),-7)

[Anonymous · Accepted solution]

Hi @naoyixue1 ,

I think -7 should in Date.AddDays function. Please try code as below.

= Table.ReplaceValue(#"Filtered Rows3","Past",Date.ToText(Date.AddDays(Date.From(DateTime.LocalNow()),-7)),Replacer.ReplaceValue,{"Week"})

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jdbuchanan71]

@naoyixue1 

I think you have an extra ')' in your new line.

Date.ToText(Date.AddDays(Date.From(DateTime.LocalNow())),-7)