Forum Discussion
Date Format Error
Hi, Hope someone can help me. I have looked through many forums but didn't come across this one. My regional settings is English (United Kingdom) and Data load type detection is set to below....
GK600 , power bi pickup date time setting from the system. I think you have this setting
If yes, on option is make it US setting.
else you have create date from this
new date =
var _pos = search("/",[Date],,0)
return
date(right([date],4), left([date],_pos-1), mid([date],_pos+1,2))
Thansk amitchandak for your response. I need it to adjust it within Power Query as some further transformation needs to be done based on this Date column.
I think you suggested DAX for Power BI desktop. Can you please suggest what can be done within Power Query. Thanks. Appreciate you taking time to respond.
Gaurav