Forum Discussion
Data issue when filtering in PQ
- 1 year ago
Hi Walt1010 Could you check for any of these issues
Check Data Types:
Ensure the date column is set to Date type. Mixed types can cause errors.Inspect Filtered Rows:
Remove the filter and check rows for invalid or blank values in the date column.Replace Errors:
- Use Replace Errors to replace invalid values with null.
- Or, use Remove Errors to exclude problematic rows.
Review Query Steps:
Check APPLIED STEPS for transformations that might corrupt the date column.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
Hi Walt1010 Could you check for any of these issues
Check Data Types:
Ensure the date column is set to Date type. Mixed types can cause errors.Inspect Filtered Rows:
Remove the filter and check rows for invalid or blank values in the date column.Replace Errors:
- Use Replace Errors to replace invalid values with null.
- Or, use Remove Errors to exclude problematic rows.
Review Query Steps:
Check APPLIED STEPS for transformations that might corrupt the date column.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance