Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Custom Filtering

I have a data set for incidents that gets a little messy. There should be two or three records for each incident ID (created, acknowledged, closed) but not all incidents are acknowledged (well most i...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Sorry, that produced a blank table

#"Custom Filter" = Table.SelectRows(#"Renamed Columns", each [Duration] <> null and [Incident ID] <> [Prev.INCIDENT_ID])
v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi Anonymous ，

 

Yes,based on your data,there is no row that meet your all criteria:

for 

[Duration]<>null and [Duration]<>""

There are only 2 rows left,but in the 2 rows,[Incident ID]=[Prev.INCIDENT_ID]

 That's why you get a blank table.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!