Datediff not showing correct dates, Please help

[SamK428113]

Have two measures with start and end time stamps displaying correctly. 

Start Measure:

Test 510 Completed = CALCULATE([Test Max Time Stamp], FILTER('CWMT_MS_QUOTINGREQUESTTRACKER - Master', 'CWMT_MS_QUOTINGREQUESTTRACKER - Master'[TASKNAME] = "510 - Generate Customer Package" && 'CWMT_MS_QUOTINGREQUESTTRACKER - Master'[TASKSTATUS] = "Completed"))

End Measure: 

Test RFP Due = MAX('CWMT_MS_QUOTINGREQUESTTRACKER - Master'[RFPRESPONSEDUEEXTERNALDATE])

Created a measure to calculate the difference between the two, but not getting the numbers as expected.

Test 1 =

VAR _c =

    CALCULATE(MAX('CWMT_MS_QUOTINGREQUESTTRACKER - Master'[RFPRESPONSEDUEEXTERNALDATE]), FILTER(ALLSELECTED('CWMT_MS_QUOTINGREQUESTTRACKER - Master'), [COMPANYNAME]= 'CWMT_MS_QUOTINGREQUESTTRACKER - Master'[COMPANYNAME]))

Var _d =

    CALCULATE(

        MAX('CWMT_MS_QUOTINGREQUESTTRACKER - Master'[TIME_STAMP]),

        FILTER(ALL('CWMT_MS_QUOTINGREQUESTTRACKER - Master'),

        [COMPANYNAME] = SELECTEDVALUE('CWMT_MS_QUOTINGREQUESTTRACKER - Master'[COMPANYNAME])

        && 'CWMT_MS_QUOTINGREQUESTTRACKER - Master'[TASKNAME] = "510 - Generate Customer Package"

        && 'CWMT_MS_QUOTINGREQUESTTRACKER - Master'[TASKSTATUS] = "Completed"))

RETURN

    DATEDIFF(_d, _c, DAY)

Test 1 results.

Any idea what is causing the issue? 

[Anonymous]

Hi @SamK428113 ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu