Forum Discussion
Issues with Time Calculations(M/Power Query & Dax) in PowerBI Service (EST & UTC)
Hello, I'm having issues with time calculations due to the difference between server time and local time. I utilize time calculations in 3 different places: M/Power Query: I have three produ...
I see that it takes the datetimelocal.now() if I was using this to transform a column / create custom column. Would it be
DateTime.Date(DateTimeZone.SwitchZone([DateTimeColumn],-8))?
edhans
Community Champion
Community ChampionIt depends on the value in that column. If there is no timezone, you'd need to build it by splitting it out, then reassembling it in the #datetimezone - PowerQuery M | Microsoft Learn function.
- edhans
You will need to play with it. The DateTimeZone.From can often convert to a timezone, then allow you to switch timezones.