Hi, I would like to propose enabling city-based timezone (such as Europe/Prague) transformation in Power Query. This way, we would be able to take into account daylight saving. For example, in Europe/Prague we have CET/CEST timezone. To transform the UTC to the correct time in Prague, I have to do a complex transformation, based on the last Sunday in March and the last Sunday in October. If you have multiple date-time columns in a table, that is a lot of transformations, that are complicated. In postgres, I can simply write: SELECT DATE(t1.date AT TIME ZONE 'UTC' AT TIME ZONE 'Europe/Prague') AS "correct_date" Therefore I would like to suggest adding this transformation feature. I believe it would save a lot of pain to everybody, who is working from countries who use daylight saving. Best regards David
... View more