Forum Discussion
dataflow datetime.from is returning weird results
Hey guys, i'm seeing some weird thing. First thing first, my regional setting locale is English (United States)
When I do this function in Workspace Dataflow (power query), i get the expected output (see screenshot below)
but when i wrap the above function with another function like so.
The datetime seem to be automatically converted to my current local datetime (which is in New Zealand).
Now the thing is, this was not use to be like this.
It use to be just convert the datetimezone to datetime format without changing the zone.
Anyone know what happened here? or experience something similar?
Thanks.
- Anonymous2 years ago
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.
1 Reply
- AnonymousNot applicable
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.