Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Date difference between two different tables

I searched the forums but could not find a solution to my particular issue.    I have a date table.     My date table is connected to "date shipped" in my shipped table, and to "order date" in the ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    I tried to create a Data model that can refer to your data model. Please find this pbix, where I created 4 ways how can you get date diff from two different tables.

    I created a common dim, Date dim. Common dim for date diff. The date dim just for your ref.

    I also populated dates from one table to another to get date diff.

     

    https://www.dropbox.com/s/y47ah38sr157l7t/Oder_delivery.pbix?dl=0

     

    Let me know if this can solve your purpose.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Due Date                  Shipped Date        Days Early/Late  

 

Jan 10 2020              Jan 15 2020                5

 

Jan 12 2020              Jan 09 2020               -3   

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

With that little information, there is nothing i can do to help you.  All i can say is that you need to create an inactive relationship and then use the USERELATIONSHIP() function.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I have given more information in my previous posts.  

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      6 years ago

      Someone else will help you.