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...
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.
edhansCommunity Champion
Community ChampionYou will need to play with it. The DateTimeZone.From can often convert to a timezone, then allow you to switch timezones.