Forum Discussion
Daylight saving malfunction with December release
Hi all, Can't find this problem on the forum, please let me know if solved elsewhere. We maintain a date table, pull through direct query to PowerBI. As of the Dec release (automatic upd...
I'm surprised this hasn't been fixed yet. Because the April daylight savings effectively adds an hour to the date, I performed the following slightly lengthy workaround:
- Use of an hour column based on the date key
- Creating a calculated column to replace the previously used date key column:
if hour = 1 then
date - 1/24
else date
More than happy to provide more details if the above explanation isn't helpful enough.
v-sihou-msft any update on this as we are having the same problem and it's quite embarrassing? Thanks
- Does anyone have updates on this issue? It is really annoying. Thanks.