Further Manipulating Date/Time

[Mario69]

Thanks to all of the suggestions I received previously.  I was able to get my calculated column to display the accurate date time by using the function +#duration(0,-6,0,0)), but my values aren't affected in my actual visual.  The visual is displaying the old DateTime value 

 

  

 

 

[lbendlin · Accepted solution]

That's not how you handle timezones.  There are dedicated functions in Power Query to do that for you.

DateTimeZone functions - PowerQuery M | Microsoft Learn