Aging Days calculation by Date Time

[Tan_LC]

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

[bhanu_gautam]

@Tan_LC , You can create a new calculated column for this using datediff

Aging Days = DATEDIFF([Datetime], NOW(), DAY)

[Tan_LC]

Hi @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 · Accepted solution]

@Tan_LC , if you want it as per 24 hour than create a new calulated column

Aging Days = INT((NOW() - [Datetime]) * 24)