Forum Discussion
Reformatting and change the order of date
LarissaM711 as this is a Locale issue, you need to process the date/time as a US type date (that's what it looks like).
Try adding this step in after the initial loading of the data into Power Query:
= Table.TransformColumnTypes(#"Changed Type", {{"Veröffentlichungszeit", type datetime}}, "en-US")
This can be done through the editor by clicking the following:
(using Locale)
Date/Time & English (US)
Hope that helps!
LarissaM711 as this is a Locale issue, you need to process the date/time as a US type date (that's what it looks like).
Try adding this step in after the initial loading of the data into Power Query:
= Table.TransformColumnTypes(#"Changed Type", {{"Veröffentlichungszeit", type datetime}}, "en-US")
This can be done through the editor by clicking the following:
(using Locale)
Date/Time & English (US)
Hope that helps!
Thank you so much 🙂