Forum Discussion
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...
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 😎
| Table 1 | Table 2 | ||||
| PROJ_NBR | CREATED_ON | PROJ_NBR | PROJ_ST_DT | Desired Results | |
| 1234 | 1/5/2022 | 1234 | 5/5/2022 | 120 | |
| 6854 | 2/18/2022 | 6854 | 3/1/2022 | 11 | |
| 8544 | 5/3/2022 | 8544 | 0 |
The first one I created an excel spreadsheet when adding the details of my request and the last one was a copy of an external excel. If you let me know how to attach an excel document I will upload it.
speedrampsSuper User
You can copy excel cells and paste them into the chat as a table.
This is safer than sending excel files which can contain nasty malware