Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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_issuestarttime] + (-7/24)
Is this best way to take date value and subtract 7 hours so that time is back in PST time zone?
Solved! Go to Solution.
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,
@v-sihou-msft/ Simon Hou
Is it planned to provide an implementation by Microsoft for
Power BI service to evaluate the browser time zone settings?
Best would be if your new implementation would do:
= Users from Australia see the same reports as those from Europa as those from the USA.
But: Those from Australia with the appropriate Australian time zone, those from Europe ...
Example:
The very same record would show 01:40 May 1, 2018 in Australia
But: 17:40 April 30, 2108 in Switzerland
And: 11:40 April 30, 2018 in New York
Regards, David
Please provide links discussing showing how to convert UTC times in report to whatever timezone the user opening the report is in.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |