Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
Need Help
Tutorial Requests
Jayrx7's avatar
Jayrx7
Frequent Visitor
4 years ago

Maybe try this?

 

DATEDIFF ( 'Candidate'[Registration Date], 'Process'[Application Date], DAY )

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi thanks for the reply Jayrx7 Unfortunately I'm getting another error now, which is this: