Forum Discussion
Solved
relative time / offset conversion from UTC time zone
using this formula to return time back to UTC, as CRM query is converting CRM data to local pacific time, but I need it in original UTC time; Column = UTC_issuestarttime = mc_alerts[mc_issuestart...
To substract hours, your approach is already the easist way in DAX. You can also try Power Query approach like:
=DateTimeZone.SwitchZone(DateTimeZone.LocalNow(),-7,0)
Please refer to articles below:
Solving DAX Time Zone Issue in Power BI
Daylight Saving Time And Time Zones In M
Regards,
To substract hours, your approach is already the easist way in DAX. You can also try Power Query approach like:
=DateTimeZone.SwitchZone(DateTimeZone.LocalNow(),-7,0)
Please refer to articles below:
Solving DAX Time Zone Issue in Power BI
Daylight Saving Time And Time Zones In M
Regards,
Please provide links discussing showing how to convert UTC times in report to whatever timezone the user opening the report is in.