Forum Discussion
littlevillage
Nov 11, 2022Iron Contributor
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.