Forum Discussion

Elisa112's avatar
Elisa112
Helper V
1 year ago
Solved

Compare dates in a summarised table

Hi Experts   I have summarise data based on columns from a customer and a training outcome table, Im gtrying to find the number of days from the customer start date to the date they found a job.  M...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, Elisa112 

     

    Is this the result you expected? If not, please provide more information.

    Days to employment = DATEDIFF([Start Date],[Outcome Date],DAY)

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Elisa112's avatar
Elisa112
Helper V
1 year ago

Hello Anonymous 

 

My summary table looks like this

 

Customer ID      Start Date        Outcome Date      OutcomeType

123                     15 Jan 2024     15 March 2024      Employed

 

I  looking for the following output:

 

Customer ID      Start Date        Outcome Date      OutcomeType    Days to employment

123                     15 Jan 2024     15 March 2024      Employed          90

 

I would rather the column days to employment is a calculated column rather than a measure

 

Thanks for your assistance

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, Elisa112 

     

    Is this the result you expected? If not, please provide more information.

    Days to employment = DATEDIFF([Start Date],[Outcome Date],DAY)

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Elisa112's avatar
      Elisa112
      Helper V
      1 year ago

      Thank you