Calculating date column as -5 hour

[Anonymous]

There is a difference of 5 hours between in the source data and my country.. I want to re-edit datetime column and show it as look like five hours ago. I don't know how to do it because Im a newbie (: Can you guys do it in the sample file I have attached?

https://drive.google.com/file/d/1bYeaGyYbnAwDU_eaGbKr37RrunglfOXk/view?usp=sharing

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

We can create another Calculated Column use following formula, then hide the old one and use the new column or we can 

Transaction Date Five Hours Ago = [Transaction Date] - 5/24

BTW, pbix as attached.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.