Delete rows with divide by zero error

[Anonymous]

Hi,

I have a numeric column which has 3 rows which throw a "Divide by zero" error. It appears as Error in the cell. I want to get rid of these rows in the Query Editor itself and not load it into my data model.

However, when I filter the column, I do not see the Error value to get rid of it. How do I delete these 3 rows?

Regards,

Vishy

[edhans · Accepted solution]

Click on the little table icon next to your view and "Remove Errors" - that removes the entire row.

Actually, in Power Query, dividing by zero will not return a div/0 error. You must be importing that from Excel, or you are using Excel terminology for Power Query. If you are importing, then the above Remove Errors will work.

If you are dividing by zero in Power Query, you need to filter out #infinity.

= Table.SelectRows(#"Added Custom", each ([Custom] <> #infinity))

[Anonymous]

Thanks @edhans , that worked perfectly. Yes, you are right, the data was imported from excel. Thanks for letting me know about the difference in Power BI and Excel error for the same.

[edhans]

Excellent @Anonymous - glad it helped.