Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Function to convert timezones by name for zones with variable offset

The DateTimeZone.SwitchZone(...) function requires you to set a definitive offset to convert between timezones. This is problematic since,in some timezones (e.g. CEST), there are summer time and winter time and hardcoded offsets would have to be changed twice a year for such countries.

Status: Needs Votes
Comments
fbcideas_migusr
New Member
Status changed to: Needs Votes
 
CjApplequist
Regular Visitor
Basic daylight savings time handling should be simple if implemented at the service level, but is way too complicated with current DAX/M/Python-integration. Please just make it easy to show data by time zone without having to adjust the calculation twice a year. Or just convince the government to abolish DST -- whichever is easier. 😉