Forum Discussion
gjadal
Microsoft Employee
Microsoft EmployeeConvert UTC to local time zone in DAX
I have a column that contains datetime in UTC. On my report, I am getting the max of it. I want to convert this UTC date to local time zone in DAX. Any pointers.?
Why you are insisting to do the conversion in DAX? Instead, an efficient solution will be to do it while importing the data using the function DateTimeZone.SwitchZone
https://docs.microsoft.com/en-us/powerquery-m/datetimezone-switchzone
Even if you are not familiar with Power Query, the actual power query will be generated in the background, you can do this in the UI itself.
This does not appear to be allowed for tables using direct query.