Enable city name based timezone transformation (such as Europe/Prague) to consider daylight saving

[zenisekd]

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