I have to fill a column in Production Table with value thats based on the value from a column “Process_Status” in Prod_Process table. The Production is referred in the Prod_Process table in column Production_IDs column which is a list.
I have written the expression and its working fine but somewhere I think it can be simplified to reduce the sync time. Can someone suggest ?
IFS(
IN("Not Processed",SELECT(Prod_Process[Process_Status],IN([Production_ID], [Production_IDs]))),
"In Process",
IN("Part Complete",SELECT(Prod_Process[Process_Status],IN([Production_ID], [Production_IDs]))),
"In Process",
OR(
NOT(IN("Not Processed",SELECT(Prod_Process[Process_Status],IN([Production_ID], [Production_IDs])))),
NOT(IN("Part complete",SELECT(Prod_Process[Process_Status],IN([Production_ID], [Production_IDs]))))
),
"Complete"
)
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |