Replace Values in Query Editor for Specific Cells

[Rsanjuan]

Is there a way to replace values in a column for specific cells in query editor?  For example, I have one column called "Meetings".  There are two types of meetings "Planned Meetings" and "Completed Meetings".  I  also have a "Planned Meeting Date" column.

There are instances of "Planned Meetings" that are earlier than Today's date, that should be changed to "Completed Meetings".  However, I do not want to changed the Planned Meeting that is after today's date. How can I do this via the query editor.  Thanks!

[Greg_Deckler · Accepted solution]

Working with date and datetime fields in M can be a little frustrating. While not a complete solution, here is an example of filtering a query based upon the local date and time (today). You should be able to use this to achieve what you want to do:

= Table.SelectRows(#"Removed Columns", each [Date] < #date(Date.Year(DateTime.LocalNow()), Date.Month(DateTime.LocalNow()), Date.Day(DateTime.LocalNow())))

Basically, this selects out the rows that are earlier than today and then you could do a find and replace on those items or base a new column on similar logic to this.