Forum Discussion

Eddie2113's avatar
Eddie2113
Regular Visitor
4 years ago
Solved

Calculated Date Column Based on Time Stamp Range

Hello,   I am looking to create a calculated date column based off a date/timestamp column in the table that calculates 1 date over a timetamp range that spans over 2 days    Example: Test_Timest...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Eddie2113 

    you can subtract 9 hours from the date/time column as follws

     

     

    Test_Date =
FORMAT ( 'Table'[Test_Timestamp] - TIME ( 9, 0, 0 ), "dd/mm/yyyy" )

     

     

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Eddie2113 

you can subtract 9 hours from the date/time column as follws

 

 

Test_Date =
FORMAT ( 'Table'[Test_Timestamp] - TIME ( 9, 0, 0 ), "dd/mm/yyyy" )