You can use DateTimeZone.SwitchZone function, for example
DateTime.LocalNow() leads to curent date and time at your location but the next fromula convert it to GMT (UTC+0)
DateTimeZone.SwitchZone(DateTimeZone.LocalNow(), 0)
Example for CST (UTC-6):
DateTimeZone.SwitchZone(DateTimeZone.LocalNow(), -6)
Example for SGT (UTC+8):
DateTimeZone.SwitchZone(DateTimeZone.LocalNow(), 😎
Example for EST (UTC-5):
DateTimeZone.SwitchZone(DateTimeZone.LocalNow(), -5)
Example for IST (UTC+5:30):
DateTimeZone.SwitchZone(DateTimeZone.LocalNow(), 5.5)
If my answer helped solve your issue, please consider marking it as the accepted solution. It helps others in the community find answers faster—and keeps the community growing stronger!
You can also check out my YouTube channel for tutorials, tips, and real-world solutions in Power Query with the following link
https://youtube.com/@omidbi?si=96Bo-ZsSwOx0Z36h
