Time zone conversion reverting

[lilych]

I'm having some trouble figuring out why one of my datetime column's time zone conversion is flipping to another time.

In Query Editor, I have converted all my datetime columns to date/time/timezone and made the timezone to 'Local Time'. This works well initially and I create measures to calculate elapsed time. I do more work in my report and review everything again and notice that one of my datetime columns now has another timezone.

For example:

A) in this one, the timezone converts and shows correctly

B) Succeeded On time is now different, while all other times are correct

Any idea why this is happening? I rechecked Query Editor and see the steps are still there and correct. 

[Icey]

Hi @lilych ,

This is really weird. I have not encountered a similar issue. 

Could you create a dummy .pbix file for us to test? Please delete other irrelevant content and sensitive information.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.