Forum Discussion
Date / Time manipulation with PowerQuery
PaddyB The easiest would be to start by setting the data type in PQ, for both start time and duration to a decimal number. Then you can simply add 2 hours (=2/24 of one day) to the start time to get CEST and then add the duration to get the end time CEST.
See attached.
thank you for your time...
i as trying to "reproduce" your script step by step as i had an error.
i already start struggling at the step of change the type of my source column
= Table.TransformColumnTypes(TeamsMeetings,{{"Start Time (UTC)", type number}})the Error from a sample line (in german)
DataFormat.Error: Die Konvertierung in "Number" war nicht möglich.
Details:
8/8/2022 11:58:26 AM
the error from a sample line (translated)
DataFormaError converting to "Number" was not possible
Details:
8/8/2022 11:58:26 AM
the source column, in my case "Start Time (UTC)" is a "Text type". this comes from a previous step. we converted there on "big message block" to this column