Hello friends, I need help with a registration and a special condition.
I have an application for recording machine work per hour but I need to learn how I can limit a multiple record if the machine has not finished being used.
In the attached image, column J records the work hours, but I want to limit that the machine that is being used (column I) is not available until hours are recorded in column J.
thanks
Well you need a colum that identifies weither the machine is in use or not. i cannot really see that info from your table. Or is the last one still in use since it has no hours? If that is the case, you can put a filter in Suggested values or Valid if of the column with the dropdown for the machines to choose from. Like:
SELECT(MachineTable[MachineID],
NOT(IN([MachineID],
SELECT(HourTable[Maquina], ISBLANK([Hora termino])))))
