Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Max Date Relative To Job Number

I have 3 Tables:   Table 1 - List of Unique Job Numbers Tabel 2 - List of Job Numbers With Original Planned Date Table 3 - List of Job Numbers With Current Planned Date (Multiple Entries Per Job ...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous ,Assuming table 1 is Job master. try like

Table 4 =
summarize(Table1, table[job],table2[Original Planned Date], "Current Planned Date",max(Table3[Current Planned Date]),"Slip",
datediff(min(Table3[Current Planned Date]),max(Table3[Current Planned Date]),day))