Avoid same dog in same day if sum of the events duration exceed another field

[Espegg]

In My app I have these fields:

- dog

- day

- start datetime

- end datetime 

- duration (difference between them)

- personal standard duration

now, each dog has a personal standard duration, like 5 Hours/day.

When i create an event, i put start datetime and a end datetime (same day) to have the duration. Now, i would avoid that a user create other event for the same dog, if the sum of all the durations for the same dog in the same day exceed the personal standard duration

[AleksiAlkio · Accepted solution]

With the validation, try something like..
(
SUM(
SELECT(Events[Duration],
AND([Dog]=[_THISROW].[Dog],[Date]=[_THISROW].[Date])
)
)
+
[Duration]
)
<=5