Forum Discussion
Anonymous
3 years agoNot applicable
Calculating the days between two date columns from different tables (DAX?)
Hi guys, I currently have two date fields in two different tables and I want to calculate the days between them. I have 'Candidate[Registration Date] & 'Process[Application Date] and I want to cal...
Anonymous
3 years agoNot applicable
Hi thanks for the reply Anonymous
For some reason I'm still getting an error
(Also apologies the date fields here are correct, I said Registration instead of Registered in my original post, that's my mistake)
Anonymous
3 years agoNot applicable
I think the problem is coming in the fact that you have informations in 2 different tables.
So show me how you want to show this result or give me information on tables like this you could find each date and use datediff
- Anonymous3 years agoNot applicable
Hi Anonymous
Sorry I'm a bit confused, I know they are in two different tables, I was hoping there was a way to make this work still, I just want to count the days between both dates, both tables are linked through an ID.