Date Error

[KKilpatrick34]

This date error keeps appearing, I am unsure how this is happening as went through data source and nothing seems different with the few rows that show this error does anyone know what might cause this? 

[Vijay_A_Verma]

The data shown in 6/6/2022 1 which has 1 at the end, hence it is not able to parse. You can can transform the column by choosing Extract - Text before delimiter and choose delimiter as space

[KKilpatrick34]

Hi thankyou for the reply! I treid this earlier and doesnt seem to clear the error not sure why

[Vijay_A_Verma]

Try trimming it. If still the error, is it possible for you to share sample data in a pbix file or Excel file having this error?