Forum Discussion
Helper IIAging Days calculation by Date Time
Hi,
I would like to count the day(s) variance as refer to the date time column using DAX.
In addition, the date time in "Now" column shall be dynamic as it shall reflect current date time at any point of time.
Kindly assist.
| Datetime | Now | Aging Day(s) |
| 29/07/2024 09:29:37 AM | 30/07/2024 10:33:24 AM | 1 |
| 29/07/2024 10:47:48 AM | 30/07/2024 10:33:24 AM | 0 |
| 28/07/2024 09:56:05 PM | 30/07/2024 10:33:24 AM | 1 |
| 28/07/2024 03:49:18 AM | 30/07/2024 10:33:24 AM | 2 |
Thank you.
Regards,
Tan LC
Tan_LC , if you want it as per 24 hour than create a new calulated column
Aging Days = INT((NOW() - [Datetime]) * 24)
3 Replies
- bhanu_gautam
Super User
Tan_LC , You can create a new calculated column for this using datediff
Aging Days = DATEDIFF([Datetime], NOW(), DAY)
Tan_LCHi bhanu_gautam , thanks for your quick response.
The result turned to be not so accurate, for example:
Datetime: 30/07/2024 7:02:57 PM
Current Datetime: 31/07/2024 2:26:14 PM
Aging Days should be 0 days instead of 1 day as it yet to reach 24 hours.
Thank you.
Regards,
LC
- bhanu_gautam
Tan_LC , if you want it as per 24 hour than create a new calulated column
Aging Days = INT((NOW() - [Datetime]) * 24)