Calculated Date Column Based on Time Stamp Range

[Eddie2113]

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_Timestamp that run between 9am on Monday 4/4/2022 to 9am on Tuesday 4/5/2022 would both return the date of Monday 4/4/2022 (Test_Date)

Test_Timestamp	Test_Date
4/4/2022 9:30am	4/4/2022
4/4/2022 8:00pm	4/4/2022
4/5/2022 4:00am	4/4/2022

The Column would define each date as 9am one day to 9am the next day and both returning the earlier date

Not sure how to structure my DAX to calculate this Test_Date Column. 

[tamerj1 · Accepted solution]

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" )