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

Hi Amit - Thank you for all of your help!!

 

I ended up adding an Orders Dim table and using Way 1 from your example.    Seems to be working perfectly! 

 

Cheers!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Amit - I marked everything as a solution and gave kudos...again very much appreciated.  

 

I did just notice one small thing that perhaps you can answer.  When I average the measure results in a table, I get 4.81.   (complete table not shown).    But if I put the measure in a card it gives me 4.70.     Also in excel I get 4.81.  

 

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    If it is measure use way4 so that line-level calculations are done and you get the same number.