Forum Discussion
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_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.
