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 ðŸ˜Ž

     

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.