Forum Discussion
Solved
Dealing with timezone issues while importing data from remote server
I was working for a client in Amsterdam and was facing timezone issue which was reflected in reports. For eg. revenue for a particular month/year was not properly shown. After several methods and res...
This is really interesting, i have not really thought about time zone issues with the service, are you saying that all your calculations assume that they are located in the Pacific time zone?
Basically, we need to have a capability to determine what time zone the user is in and adjust the calculations to reflect it properly...
Hi ashishrj Can you tell me how you did this.
I have tried your process a few different ways. For me its (13/24) as I am in New Zealand +13 hours. But I cant get the right daily totals to show on PowerBI online. Everything looks fine in the Desktop app but when uploaded the totals don't match till 1pm (+13 hours).
Where did you apply the calcuated column? In a Date Table or in the actual data table?
Cheers
ED