Local Time date format

[rafajammali]

My date format has *3/14/2001 1:30:55 PM (G), whats that G refrence to ? is that the time Zone, if yes how did power bi know that and how to change it to a diffrent time zone.

[Anonymous · Accepted solution]

@rafajammali 

G = General date/time pattern

Power Bi uses the date/time and time zone on your device, usually it is auto setting, you can change the time zone in your PC setting. 

Paul Zheng

[amitchandak]

Seems like general time format

please refer for more details

https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings.

Also, just check that has power bi; got it like DateTime or text. Sometimes it shows like datetime but datatype is text.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin