Forum Discussion
Date Time Fields
Hi All, I'm getting a date and time from a sharepoint list and im struggling to get the field to show in my local time zone in power bi desktop I just want to display this date and time in ...
danextian
Super User
Super UserHi theBlessedCobba ,
What is your target timezone in UTC? You need to convert AEST to its UTC equivalent and then use that to switch to another timezone. Here's a sample M formula:
DateTime.From( DateTimeZone.SwitchZone([DTZ column], <utc timezone>))