Hi. I have the following expression as an initial value to pull the MAX time that exists in the table. MAX(SELECT(Works_Orders_Master[Production Finish Time],[Date of Production]=[_THISROW].[Date of Production])
Is there anyway that I can incorporate fields called [Department] & [Area] from an associated table called (Routings_Master) - associated through [Record ID] as Ref type.
Something like
MAX(SELECT(Works_Orders_Master[Production Finish Time],AND([Date of Production]=[_THISROW].[Date of Production],
Routings_Master[Department]=[_THISROW].[Department],Routings_Master[Area]=[_THISROW].[Area])))
Hope that makes sense.
Many thanks.
Maurice.
If the Record ID column is a column in the Work_Orders_Master table:
MAX(
SELECT(
Works_Orders_Master[Production Finish Time],
AND(
[Date of Production]=[_THISROW].[Date of Production],
[Record ID].[Department]=[_THISROW].[Department],
[Record ID].[Area]=[_THISROW].[Area]
)
)
)
See also:
Thank you so much @Steve
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |