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.