Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey Microsoft and others,
Yesterday I stumbled upon strange behaviour from the TIME() function in Power BI. I have a column with timestamps represented in the following format: 6/22/2022 8:03:01 PM and want a new column that contains this time converted to UTC (adding 3 hours). Note: the data comes from direct query so I can not change the timezone during data transformation.
What I did:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @
When testing it in Import data, it works well.
Just as the official document said, TIME function is not supported for use in DirectQuery mode when creating calculated column. Fore more details, you could refer to TIME function (DAX) - DAX | Microsoft Docs.
\
Best Regards,
Community Support Team _ Caiyun