Forum Discussion

littlevillage's avatar
littlevillage
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 đúng giờ] <> "#VALUE!")

But it not working.

Hope for your help.

Thank you.

Resources