Forum Discussion

Tan_LC's avatar
Tan_LC
Icon for Helper II rankHelper II
2 years ago
Solved

Aging 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...
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

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

     

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

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
2 years ago

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

 

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