How to Fix Power Query Date Error

click on the ABC icon for this select dates power query is returning this as month day Yo which is the regional settings of our computer as it is set to the US the moment that the number goes over 12 how query returns an error because there is no month 13. we need to remove this change type step here a selecting date makes power query think that the date is set in your computer's Regional settings which is the US of man day yo we need to use the correct local meaning we need to select the region from where the data comes from so this prompt comes up we'll change type with local our data type select dates local will be range France select that select OK and we have the correct order date

Channel: Miss Microsoft

Views: 7,926

Keywords:

Id: OrVzn8YFVgc

Length: 0min 56sec (56 seconds)

Published: Mon Jun 05 2023