Forum Discussion
Daylight saving malfunction with December release
Having this exact same issues with the April 2018 release.
The April 2018 date an hour is being added.
seems weird as april dates in other tables aren't affected.
I'm finding the way issue when the report is published to the web.
the fix seems to be to go to the computer date time settings and switch off automatically adjust for daylight saving.
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.
