data load showing error

Problem with Date Parsing in Power Query

When I upload a file into Power Query, I encounter an error in the Main Sheet related to date parsing.

This issue is causing approximately 11,000 rows to be excluded or missing from the dataset because the dates in those rows are represented as --, which Power Query cannot interpret as a valid date format.

I need to ensure that all rows are included in my analysis, even the ones with missing or invalid dates, and to fix this issue by replacing the -- values with valid dates (e.g., using previous rows' dates). How can I handle this in Power Query to resolve the error and show all the rows in the Main Sheet, including filling in the missing dates correctly?

This provides a clearer explanation of the issue while specifying the context, error details, and the desired outcome (showing all rows and replacing invalid dates).