Forum Discussion

TungNguyen_19's avatar
TungNguyen_19
Icon for Helper III rankHelper III
2 years ago

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...
Need Help
TungNguyen_19's avatar
TungNguyen_19
Icon for Helper III rankHelper III
2 years ago

Hi, thanks for your reply. I have read it but refer to this "a replace function to check all the data fields to replace the NA to null " I don't know how to create this function by M language. Can you please show me how to do this if you know?