Forum Discussion
Inconsistent Date Conversions
I've been going in circles trying to get my date/time values correct in my online Service reports, trying to get consistent results in the context of the automatic conversion of times to UTC standard...
Hi _Nick_
What I would recommend doing is to change your datetime values in power query. That way when the data is coming into your model, the date time format is already established to be what you expected to be and you're not having to use dax or calculated columns to create this. This can very often create some of the issues you are experiencing.
Here are details on how to change the date time in Power Query: Power BI – Did you know ALL Power BI Services Servers are in UTC? Now how to handle it for Dates & Times - FourMoo | Power BI | Data Analytics
Unfortunately, Power Query isn't an option for Direct Query mode, which I require to make use of automatic updating features.