Format a column from text to date

Hi all,

I like to change the format of a column to date with the following values:

EndPricingPeriod

As you can see there are two formats of the dates.

When I try to convert the values I get an error on the ones that look like '202107':

DataFormat.Error: We couldn't parse the input provided as a Date value.

I'd like to format these values to date type in Power Query as well.

Does anyone know how to do this?

Thanks!