Forum Discussion
kirabray
3 years agoRegular Visitor
Difference Between a Column Time and Now
Hello!
I am trying to get the number of hours difference between an "Approval Time" and the current time. I am getting an unexpected result, I'm guessing because of the datetime format of the Now() function. If right now is 4 pm, is there a simple way to just see "2" as the result?
1 Reply
- ToddChittSuper User
Please check out the DATEDIFF DAX function: DATEDIFF function (DAX) - DAX | Microsoft Learn
You can specify the Interval as Hours