Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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
Solved! Go to Solution.
@Tan_LC , if you want it as per 24 hour than create a new calulated column
Aging Days = INT((NOW() - [Datetime]) * 24)
Proud to be a Super User! |
|
@Tan_LC , You can create a new calculated column for this using datediff
Aging Days = DATEDIFF([Datetime], NOW(), DAY)
Proud to be a Super User! |
|
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
@Tan_LC , if you want it as per 24 hour than create a new calulated column
Aging Days = INT((NOW() - [Datetime]) * 24)
Proud to be a Super User! |
|