topic Re: Aging Days calculation by Date Time in DAX Commands and Tips

Aging Days calculation by Date Time

Tan_LC — Wed, 31 Jul 2024 05:45:40 GMT

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.

Thank you.

Regards,

Tan LC

bhanu_gautam — Wed, 31 Jul 2024 06:09:21 GMT

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

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

Tan_LC — Wed, 31 Jul 2024 06:27:49 GMT

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,

bhanu_gautam — Wed, 31 Jul 2024 07:04:36 GMT

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

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