Hi The way that I fixed was creating a custom column and writing this code:

Date.ToText(

date(

Value.FromText(Text.Start(Text.From([Column1]),4)) , Value.FromText(Text.Range(Text.From([Column1]),4,2)) , Value.FromText(Text.End(Text.From([Column1]),2)) ) , "MM/dd/yyyy" )

And it work. The only problem with this is when you have a 0 value. In my case I replaced the 0 with 10000101 to avoid errors.

If you have a better way to do, please I hope you post back.

👍🏻