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.
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.
Hi Amit - Almost there!
Changing to avg on the visual did fix that issue.
However, now I am noticing a different issue. The measure is not returning all of the records. In the shipped table for January there are 435 disctinct records (orders). But the measure is only returning results for 37.
As orders might me repeating it is grouping those up. Can add other columns and try.
Or check distinct order , by putting them into a matrix