Forum Discussion
Tan_LC
Helper II
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...
Tan_LC , if you want it as per 24 hour than create a new calulated column
Aging Days = INT((NOW() - [Datetime]) * 24)
bhanu_gautam
Super User
Super UserTan_LC , You can create a new calculated column for this using datediff
Aging Days = DATEDIFF([Datetime], NOW(), DAY)
Tan_LCHelper II
Helper IIHi 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)