Hello team. Given that ODBC is returning datetime ...
# suiteanalyticss
sholomon12
07/09/2023, 12:06 AMHello team. Given that ODBC is returning datetime in UTC timezone, has anyone solved this on aligning to current local time (such as Sydney +10) through Power BI ? What's your best approach?
m
Marc
07/09/2023, 2:54 PMNewDate = DateTimeZone.SwitchZone(Table[Date],10)
m
michoel
07/10/2023, 11:06 PMI don't think this will handle DST?
s
sholomon12
07/11/2023, 1:40 AM@Marc thanks much! However I am using DirectQuery which I believe this is not applicable?
sholomon12
07/11/2023, 1:40 AM@michoel yeah that one as well, i saw multiple formulas over the internet but all of them requires 'Standard Import' instead of DirectQuery to manipulate the table columns. i do wonder what's the best approach