Forum Discussion
How 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...
try the following:
1) remove the change data type step
2) remove errors
3) apply the new data type
Sorry 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)
see my video
= Table.ReplaceErrorValues(tbl_Table, List.Transform( Table.ColumnNames(tbl_Table), (x)=> {x, null}))