Forum Discussion
Solved
Timezone Switch
I have a report that is being refreshed on the service. As with so many others I'm trying to convert UTC to a local timezone. I've read many similar posts but still not getting something quite r...
Hi PBI_Rookie ,
You could use #duration().
https://docs.microsoft.com/en-us/powerquery-m/sharpduration
[datetime]+#duration(0,-7,0,0)DateTime.LocalNow()+#duration(0,-7,0,0)Best Regards,
Jay
Hi PBI_Rookie ,
You could use #duration().
https://docs.microsoft.com/en-us/powerquery-m/sharpduration
[datetime]+#duration(0,-7,0,0)DateTime.LocalNow()+#duration(0,-7,0,0)
Best Regards,
Jay