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.

     

amitchandak's avatar
amitchandak
Super User
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!