Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculating date column as -5 hour

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

Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    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.

     

1 Reply

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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.