Forum Discussion
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 ...
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.
.Yes, I created 2 calculated columns in the Orders table
Way 2 Delivery Date = maxx(filter('Flu Shipped','Flu Shipped'[Order]=Orders[Order]),'Flu Shipped'[Date Shipped])
Way 2 date Diff = DATEDIFF('Orders'[Due Date],'Orders'[Way 2 Delivery Date],DAY)
I checked the lines and that was not the issue. I am still getting what seems to be random strange results.
Anonymous
Are checking result at table level or visual level. In the case of visual level change Agg to Avg. There seems to be more than one line for the order.