Forum Discussion
Difference between two dates - from two different tables
I am trying to calculate our on time performance. Date due vs date shipped. I have a date table. The relationship between Flu Shipped and the date table is with "Date Shipped" and on the...
Hi,
Sorry to a noob. But create a relationship between my date table and these? I have that already.
Or just create a relationhip, between the order table and the shipping table? If so, from which field to which field? And won't this be a many to many relationship?
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.