Dates/Times in selected Timezones

dr2506 · ‎07-12-2023

Hi all,

We have a service desk data that we export from our ITSM tool via API into PowerBi Service. When uploaded the dates/times are in UTC format. For the UK we simple adjusted all these by creating new columns using a simple formula to add 1 hour when in BST and leave as is when in GMT. My US colleagues are now using the system so I have been trying to find a way to have the system updated the dates/times based on selected timezone.
I have used static tables to create the zones and time differences and another for Daylight savings and can create measures to calculate the new logged/closed times. This works if I have a table view and add the measure in.
My issue is that I need these to be columns as we base a lot of reports on these dates/times. As you already know you cannot create a column based on measures as these are not recalculated based on a filter nor can I base reports from the measure.
Any ideas or advice in how we can overcome this please?

dr2506 · ‎07-16-2023

Thanks for the response. I have looked at these and can have the dataset calculate to one timezone. This is what I actually did for the UK times. What I am trying to work out if there is a way for the user themselves to select one of four time zones and the data set recalculate. From my testing you can only update columns on refresh not when filtered. Currently looking at re-engingeering all my measure so they take into account of the filter and recalculate the figures. A little complicated but hopefully will work.