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.
I have given more information in my previous posts.
Someone else will help you.