Forum Discussion

gjadal's avatar
gjadal
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Convert 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.?
okellyc's avatar
okellyc
Icon for Advocate I rankAdvocate I
3 years ago

It's mind blowing how many litttle tiny things that you would expect to be easy and out of the box, require a WAY over engineered DAX expression.  Even just sorting a table how I want requries an hour of reserarch and another 30 min of writing DAX.  

 

Why in the world would PBI Service not be configured to show the local time that is in the report?