Forum Discussion
Difference DateTime between Desktop and Service
For Date column, it will always show UTC time on Power BI Service, you can create a custom column and use DataTimeZone functions to set time zone. For more details, please refer to articles below:
Solving DAX Time Zone Issue in Power BI
Daylight Saving Time And Time Zones In M
Regards,
For Date column, it will always show UTC time on Power BI Service, you can create a custom column and use DataTimeZone functions to set time zone. For more details, please refer to articles below:
Solving DAX Time Zone Issue in Power BI
Daylight Saving Time And Time Zones In M
Regards,
Thanks for your answer. I have always saw this tips but in French, we are in UTC+1 in winter but in UTC+2 in summer.
So, I can not just add one (or two) hour.
I find a solution by using a calendar table. In this table, I add a field who give the numbers of hours to add depending on the date.