Is there an equivalent to SQL's "AT TIME ZONE" function?

[cyclist007]

Hi,

I was wondering if anyone is aware of the M query function or DAX function which provides time zone conversion from UTC to a specified time zone in the Power BI service.

In SQL we can use the "AT TIME ZONE" function to achieve this as follows:

Select Cast (start_datetime AT TIME ZONE 'UTC' AT TIME ZONE 'Central Standard Time' As Datetime) AS start_datetime_new

(The "AT TIME ZONE" function handles daylight savings)

I cannot find an equivalent to this in Power BI, where if i can provide the time zone name (such as Central Standard Time") as an input. The expectation is it should convert that row/record from UTC to CST (-5 or -6 hours) based on the date-time of the year (that is if the date-time in data is before/after daylight savings change for that calendar year).

The new time zone name would be available in the data (as a seperate column), and it could change for different objects/locations.

[GilbertQ]

Hi @cyclist007 

My blog post here should allow you to set the timezone offset: Using Power BI to ensure Daylight Savings Dates and Times change dynamically - Reporting/Analytics M...

[cyclist007]

@GilbertQ 
I am not an M query expert, but from what i understand the start and end dates are for a particular year and woud have to be updated. Would need something more generic that can span across years and can also accomodate different time zones. In SQL, we can use "AT TIME ZONE" function that does the logic in determining the offset (based off timezone provided and if the actual date falls under daylight savings period or not). I am trying to have a calculated column for the new time zone, and data can span accross years (and ideally across time zones which are based in asset/location on that row/record).