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.?
jjudas_CPAdv's avatar
jjudas_CPAdv
Frequent Visitor
5 years ago

Ran across this sort of issue in a project I'm working and in scanning the several response ideas, why not just add a "UTC adjust" column to the Date Table in your model and populate it accordingly for your timezone and or daylight savings impacts ( e.g. 4/24 for standard and 5/24 for DST)?

 

Then reference that column value in any calcs as needed.