Forum Discussion
Date/Time Changing Inconsistently
Hi all,
I have a column of date/time. I expected PowerBI to change it based on UTC, which I know how to edit/account for. Except what I'm finding now is that some dates are changing by 4 hours and others are changing by 5. I cannot find a pattern as to what ones are following what rule and I cant figure out why theyre changing inconsistently.
I want to change all the date/times to match my original data but I cant when they arent changing by the same amount of hours.
The Date/Time Format from my original data is Column A.
Column B-D is what is coming out of PowerBI.
Column E is showing 2 of them are off by 4 hours and the other two are off by 5 hours.
My data in reality is thousands of lines long and will be updated weekly with more data, so I need to write a new column that will account for all possible situations with the Date/Time but just a simple +4 or +5 wont work since its not consistently changing.
Any ideas as to whats happening and how to fix it?
It looks like it has something to do with daylight saving time (october is not in DST time so a 4 hours difference, november and january are in daylight saving time so 5 hours of difference).
You can change the way Power BI handles time zones in Power BI Desktop. To do so, go to:
file > options & settings > Options > Regional settings (current file) > change the locale to your desired setting
3 Replies
It looks like it has something to do with daylight saving time (october is not in DST time so a 4 hours difference, november and january are in daylight saving time so 5 hours of difference).
You can change the way Power BI handles time zones in Power BI Desktop. To do so, go to:
file > options & settings > Options > Regional settings (current file) > change the locale to your desired setting
Anonymous ,
I believe this is the reason:-
-
Daylight Saving Time 2020
- began Sunday, March 8
- ended Sunday, November 1
-
-
