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 calculate the days between them, is there any way you can do this with a simple DAX measure? I can't create a custom column because they are both in different tables, any help would be appreciated 

Need Help
Tutorial Requests

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi, tryn this

     

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

    • 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 )