Forum Discussion

CCWhatsup's avatar
CCWhatsup
New Member
7 years ago

Help with DATEDIFF?

Hi,   I have a visual with 2 dates from different tables that I need to get the difference between in order to get actual response times for our calls.   Column 1 is:  Job[Job_Created_Date] Colu...
Need Help
jdbuchanan71's avatar
jdbuchanan71
Super User
7 years ago

Hello CCWhatsup 

Give this a try.

Days =
DATEDIFF (
    SELECTEDVALUE ( Job[Job_Created_Date] ),
    CALCULATE (
        MIN ( JobResourceWorkTime[Work_time_start] ),
        JobresourceWorkTime[Work_time_type] = "working time"
    ),
    DAY
)

 

  • CCWhatsup's avatar
    CCWhatsup
    New Member
    7 years ago

    Thanks for the reply. This seems to generate blank results in the column that it creates. No errors though.

    • jdbuchanan71's avatar
      jdbuchanan71
      Super User
      7 years ago

      CCWhatsup 

      Are you trying to add this as a calculated column or in a card visual or matrix?  Could you share your .pbix file and show the location where you are trying to add the value?  It will help us to give you the right answer.