Date Filter in Power Query

[jtomczyk]

Hallo, 

I would like to have one button to remove all projects that were done in last 30 days.

To do that I have added new conditional column in power query. I do not know why it doesn't work. Any idea?

= Table.AddColumn(#"Replaced Value8", "YYY", each if [Date] < Date.AddDays(DateTime.LocalNow(),-30) then "Wrong" else "Correct")

[v-yalanwu-msft · Accepted solution]

Hi.， @jtomczyk ；

Because your [Date] column is in Date format and date.adddays (datetime.localnow (), -30) returns Date/Time format, the two formats are not comparable in power Query, so you cannot use <;

so we could change the Date column to Date/Time format . then compare them.

= Table.AddColumn(#"Changed Type1", "Custom", each if [Date]<Date.AddDays(DateTime.LocalNow(),-30) then "Wrong" else "Correct")

Or change the other column to Date format.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[amitchandak]

@jtomczyk , what we do is we had a filter in power query with the static date on the data then go and replace the static date with this one

Date.AddDays(DateTime.LocalNow(),-30)

[jtomczyk]

Hallo @amitchandak 

For the static date it works

when I replace that date with Date.AddDays(DateTime.LocalNow(),-30) I get error to all values