Date/Time Changing Inconsistently

[Anonymous]

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?

[Anonymous]

Thanks both! You are both correct...I didnt even consider Daylight Savings! 

[rsbin]

@Anonymous ,
I believe this is the reason: 

• • Daylight Saving Time 2020

    • began Sunday, March 8
    • ended Sunday, November 1

[Smalfly · Accepted solution]

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