Forum Discussion
Date difference between two different tables
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.
Hi,
Take a simple example and show the expected result.
Due Date Shipped Date Days Early/Late
Jan 10 2020 Jan 15 2020 5
Jan 12 2020 Jan 09 2020 -3
Anonymous
Please check the solution in file, if that can help https://www.dropbox.com/s/y47ah38sr157l7t/Oder_delivery.pbix?dl=0
Hi Amit -
Thanks so much for that file...it was great...something I can learn from.
I tried "way 2" and it seems to work, although I am getting results for dates that have not even happened yet. See image. Note the first two dates.
Hi,
With that little information, there is nothing i can do to help you. All i can say is that you need to create an inactive relationship and then use the USERELATIONSHIP() function.
I have given more information in my previous posts.