Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 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
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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)

 

Jayrx7's avatar
Jayrx7
Frequent Visitor
3 years ago

Maybe try this?

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

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