dataflow datetime.from is returning weird results

Hi holidays511 ,

To see you local timezone, use power query function:

DateTimeZone.LocalNow() 

Or DAX function:

LocalTime = now()

To change timezone, use power query function:

 = DateTimeZone.SwitchZone(dateTimeZone, timezoneHours , timezoneMinutes )

 In addtion, please refer to:

Solving DAX Time Zone Issue in Power BI - RADACAD

DateTimeZone.SwitchZone - PowerQuery M | Microsoft Learn

DateTimeZone issue - Power Platform Community (microsoft.com)

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.