Forum Discussion
Calculate values based on difference between 2 Dates
- 5 years ago
Tarun-Bhatia , One way is populate date from one table 2 another , asuume order no or some key is there
new columns
Table 1 Actual Delivery Date = maxx(filter(Table2, Table2[order no] = table1[order no]),Table2[Actual Delivery Date])
Table 3 Actual Delivery Date = maxx(filter(Table2, Table2[order no] = table3[order no]),Table2[Actual Delivery Date])
Table 3 Planned Delivery Date = maxx(filter(Table1, Table1[order no] = table3[order no]),Table2[Planned Delivery Date])
You can take date diff as columns now .
Or refer how to take across table date diff
refer if need
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
Tarun-Bhatia , share some sample in table format
Hoping below might help? Tables are linked through Date_ID