Forum Discussion
Calculate values based on difference between 2 Dates
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 , 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
Forgot to mention
Table:3 has got "Planned_Date_ID" & "Delivered_Date_ID" which is used to link between Planned date in table 1 & Delivery date in table 2.
Maybe we could use that some way
Thanks