In my opinion, the best way to deal with it is by using Power Query in Power BI and change it by using the option LOCALE. This will make all files have a standard format in the DATE column.