Forum Discussion
TungNguyen_19
Helper III
Helper IIIHow to filter #N/A only in Power Query?
Hi everyone, Today I have to import over 20 files Excel to Power Query and I face the Error which point out that there are #N/A in the files. The problem is I can not use Replace Error option becau...
TungNguyen_19Helper III
Helper IIISorry but I don't want to remove rows contain N/A which cause error in Power Query, I just want to filter it and replace it with null (But other solution beside "Replace Error" function)
Ahmedx
Super User
Super Usersee my video
= Table.ReplaceErrorValues(tbl_Table,
List.Transform( Table.ColumnNames(tbl_Table), (x)=> {x, null}))