Forum Discussion
Solved
Edit Query Filtering Problems
I have a large amount of data with around 800,000 rows on specific sales that were recorded. I have a column for original purchase date, quarter, year, sale price, and also division (the divisions in...
- cole_lehmkuhler you first need to change data type of date column to Date which will result in rows with N/A to be error out. Then use Replace Error function and get rid of those errors with null or other date.
My mistake I misread your response the first time, and it didn't work. I just started working with it again and went back to see if anyone else had responded and reread your answer and realized you were correct. Thank You!
I also had this error of invalid value "#N/A" and solved by applying Replace Error step before other operational query steps. If I apply Replace Error at the end of the query list then it won't work because the error can occur during one of the earlier steps.