Filtering a table by "recently completed"

#1

Hi folks, I’m curious how to filter a table by “recently completed”.

In my table this means showing all rows where the “status” column was changed to “done” yesterday.

1 Like
#2

@Devin_McIntire

Table.Filter([status]=done AND [date completed]=today()-1)

  • [status] column type is “Select list” or “Lookup from table”
  • [date completed] column type is “Date”
1 Like
#3

Thanks @Ander !

I realized I first needed to create a “created date” column:

  • if(Status=“Done”, Status.modified(), “”)
    And then filtered the table based on that.
1 Like