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
v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi  Anonymous ,

 

Use below M codes:

let
    Source = Table.SelectRows(Table,each [Duration]<>null and [Duration]<>"" and [Incident ID]<>[Prev.INCIDENT_ID])
in
    Source

Check my sample .pbix file attached.

 

Best Regards,
Kelly

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

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!