Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculate days between dates in different tables

Can someone please provide me with assistance. I have 2 tables which are joined on a Project # and need to find the number of days between Created On Date  and Project Start Date. Below is an example...
Need Help
  • speedramps's avatar
    speedramps
    4 years ago

    Hi rohit_singh

     

    Thanks for your help, but please check your solution suggetion .....

    var _datediff = DATEDIFF('DatesBetween'[CREATED_ON],'DatesBetween'[PROJ_ST_DT],DAY)

     

    Wont the DatesBetween'[CREATED_ON]  return a buggy table value ? 🤔

     

    You need to wrap it in a SELETEDVALUE, MIN or MAX to get a scalar value.

    See  method I suggested.

     

    Many thanks 😎

     

rohit_singh's avatar
rohit_singh
Icon for Solution Sage rankSolution Sage
4 years ago

Hi Anonymous ,

Please try creating a calculated column on your table as shown below :

Duration =

var _datediff = DATEDIFF('DatesBetween'[CREATED_ON],'DatesBetween'[PROJ_ST_DT],DAY)

return
if (isblank(_datediff), 0 , _datediff)

This should give you the desired result.


Kind regards,

Rohit


Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 😊

speedramps's avatar
speedramps
Icon for Super User rankSuper User
4 years ago

Hi rohit_singh

 

Thanks for your help, but please check your solution suggetion .....

var _datediff = DATEDIFF('DatesBetween'[CREATED_ON],'DatesBetween'[PROJ_ST_DT],DAY)

 

Wont the DatesBetween'[CREATED_ON]  return a buggy table value ? 🤔

 

You need to wrap it in a SELETEDVALUE, MIN or MAX to get a scalar value.

See  method I suggested.

 

Many thanks 😎

 

  • rohit_singh's avatar
    rohit_singh
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi speedramps ,

    Thanks for your feedback. I have created a calculated column and not a measure so it will work as expected.