date displayed with minus hours power bi

[domcv]

have a date column in the table. But i saw that minus values with dates.

ex: -0400 

What does this mean? need to convert it to date format so when i convert it to date format it gives column like this.

actual date is 2022/06/08 but after converting to date format it gives 2022/06/09. I guess this is due to minus hours. Any method to fix this issue? 

[hansei · Accepted solution]

There is no subtraction going on there. The timestamp includes a timezone. If you do not care about the timezone, you can remove it. Unsure what your transformation looks like, but you will want to change it from code akin to Custom1 in the example to Custom2

let
    Source = Table.FromRows({{"2022-06-08T02:39:57.088-0400"}}),
    #"Added Custom1" = Table.AddColumn(Source, "Custom", each Date.From(DateTimeZone.FromText([Column1]))),
    #"Added Custom2" = Table.AddColumn(#"Added Custom1", "Custom2", each Date.From(DateTimeZone.RemoveZone(DateTimeZone.FromText([Column1]))))

in
    #"Added Custom2"