How can I get PowerBi to my display order dates in the correct timezone?

[ianwuk]

Hello All.

I have order data where the date of the order is given in UTC.

For example:

Order ID    Order Date
123456      28/02/2018 21:07:05 UTC - this is correct because it is in February!

However, in PowerBi, it looks like this:

Order ID    Order Date
123456      01/03/2018 04:07:05 AM - this is not correct because now it is March!

How can I correct this? 

It means that right now, for my monthly March order report it is actually including February orders from last month.

Many thanks.

[v-juanli-msft · Accepted solution]

Hi @ianwuk

For your example, the time in UTC is 28/02/2018 21:07:05, and your local time is 01/03/2018 04:07:05 AM, this is to say you are now in UTC +7.

One workaround is to subtract seven hours from the order date for all records in the table,

Column =
[Order Date] - TIME ( 7, 0, 0 )

Best Regards

Maggie

[ianwuk]

Can you possibly help @v-yuezhe-msft or @Zubair_Muhammad, please?