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...
rubayatyasmin
Community Champion
Community ChampionHi, TungNguyen_19
Excel #N/A values are the result of formula error, you can use IFERROR and ISNA in Excel to filter the N/A.
refer: Excel Find and Replace #N/A - Super User
How to correct a #N/A error - Microsoft Support
- TungNguyen_19
Hi thank for your reply but I want to do this in Power Query with M language
