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

Anonymous 

I am assuming, you have created both new columns as calculation. Can you share the formula

Anonymous's avatar
Anonymous
Not applicable
6 years ago

.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.