Forum Discussion

Iron Contributor

Nov 11, 2022

How can remove errors "#VALUE!" in Power Query.

Hi, I have an issue in Power Query: "DataFormat.Error: Invalid cell value '#VALUE!'. I try to filter by this formula: = Table.SelectRows(#"Filtered Rows1", each [PU đúng giờ] <> "#VALUE!") But...

excel

Formulas and Functions

Detlef_Lewin

Silver Contributor

Nov 11, 2022

littlevillage

Try "Remove errors".

https://support.microsoft.com/en-us/office/remove-or-keep-rows-with-errors-power-query-67046a11-e9f1-4911-a3b1-e9d9fb9e8831