Convert Timezone Using Timezone Database Format

Hi Anonymous ,

Based on your description, you want to raise a query about time zone conversion using the TZ database format. Your method does not directly support TZ database identifiers (e.g., "America/Chicago") as input to the time zone parameter. This method typically requires a numeric offset from UTC, not a named time zone identifier.
You can create a region column to map to the TZ data to match the offset and then use DateTimeZone.SwitchZone().
DateTimeZone.From - PowerQuery M | Microsoft Learn
DateTimeZone.SwitchZone - PowerQuery M | Microsoft Learn
How-To: Convert UTC to Your Local Time Zone in Pow... - Microsoft Fabric Community

Best regards,
Albert He

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