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.?
Anonymous's avatar
Anonymous
Not applicable
4 years ago

add a new column:

AdjustedDateTime = OriginalDateTime + Time(10,0,0)

 

adds 10 hours