How can I filter on close date, but ensure any incidents still open are not filtered?

[jimb1955]

This works great but also filters out any ticket that could be blank or pending or in work as such but we need to keep those tickets.

The file has several years worth of data and were trying to shrink it down.

#"Filtered Rows" = Table.SelectRows(#"Removed Columns", each [Date Closed UTC] > #datetime(2020, 6, 30, 0, 0, 0))

[amitchandak · Accepted solution]

@jimb1955 , Either create a column or try script like

[Date Closed UTC] > #datetime(2020, 6, 30, 0, 0, 0) and  [Status] <> "Closed"

[Date Closed UTC] > #datetime(2020, 6, 30, 0, 0, 0) or  [Status] = "Open"

[Date Closed UTC] > #datetime(2020, 6, 30, 0, 0, 0) or [Date Closed UTC]  = null 

[jimb1955 · Accepted solution]

Thank you that worked great.

[amitchandak · Accepted solution]

@jimb1955 , Either create a column or try script like

[Date Closed UTC] > #datetime(2020, 6, 30, 0, 0, 0) and  [Status] <> "Closed"

[Date Closed UTC] > #datetime(2020, 6, 30, 0, 0, 0) or  [Status] = "Open"

[Date Closed UTC] > #datetime(2020, 6, 30, 0, 0, 0) or [Date Closed UTC]  = null