Forum Discussion
Time Zone issue
- 8 years ago
Yes, I'm 2 hours ahead of GMT (Central European Time), andI want to present data based on EST time (NYC time). What I did so far:
My PC settings is English (United States). Power BI settings is Enhlish (US) too.
I have "Time" column that shows GMT time (see below):
Then I added Local Time column in Power Query Edutor that converts GMT from Time column to local time (-4:00). And I got what I wanted in Power Query Editor.
But, a problem arises here. When I load Local Time data to a table I see my Central European time in the table column despite my PC settings and Power BI settings are English (US).
So instead of 9:45:54AM as in Power Query Editor, I see 3:45:54PM in my table.
I am curious to know why this happen. The local time that I see in Power Query Editor should be loaded to my table if the settings is correct.
In the meantime I solved this by adding another column to a table with a formula, but it would be great if I can do this without additional column.
LocalTime 2 = MyTable[LocalTime] - .25 ---> 0.25 = 6/24 (I am 6 hours ahead of EST).
------
How I got the local time:
=DateTimeZone.ToLocal([start_time])
Where [start-time] column shows time from my server (GMT) that is converted to local time (EST).
Yes, I'm 2 hours ahead of GMT (Central European Time), andI want to present data based on EST time (NYC time). What I did so far:
My PC settings is English (United States). Power BI settings is Enhlish (US) too.
I have "Time" column that shows GMT time (see below):
Then I added Local Time column in Power Query Edutor that converts GMT from Time column to local time (-4:00). And I got what I wanted in Power Query Editor.
But, a problem arises here. When I load Local Time data to a table I see my Central European time in the table column despite my PC settings and Power BI settings are English (US).
So instead of 9:45:54AM as in Power Query Editor, I see 3:45:54PM in my table.
I am curious to know why this happen. The local time that I see in Power Query Editor should be loaded to my table if the settings is correct.
In the meantime I solved this by adding another column to a table with a formula, but it would be great if I can do this without additional column.
LocalTime 2 = MyTable[LocalTime] - .25 ---> 0.25 = 6/24 (I am 6 hours ahead of EST).
------
How I got the local time:
=DateTimeZone.ToLocal([start_time])
Where [start-time] column shows time from my server (GMT) that is converted to local time (EST).