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 AEST +10, here is what the field looks like, if i drop the timezone from the format (like the one on the right) is just shows the utc time, it should say 8am to 5pm
thanks in advance (i really hate date time fields)
8 Replies
Hi 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>))Hi danextian
Did not work, regardless of what number i add into the timezone, the time never changesCan you please show a screenshot that shows other number aside from 10 as the timezone?
