Forum Discussion
AlanP514
Post Patron
Post PatronHow to Fix This Date Column Format in Power BI itself
Hai Team,
I need some help, in this Sc Attached facing an error
Column called ticket Date, But Few Dates are like
1/1/2023, Few are like 1/1/23, Due to this error is showing how to fix this
2 Replies
- serpiva64
Solution Sage
Hi,
your example is not completely clear to me.
in row 102 the date is 22 of february 2013?
in row 103 the date is 2 of november 2013?
If it is so you can change type using local and you get no error
from this
using locale
you get
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
pankaj_lpHelper I
Its probably due to the default settings as dd/mm/yyyy format , try changing it to mm/dd/yyy
