Hello,
I need your help for a substraction of lists.
I have the first table with the list of the rooms (1, 2, 3, 4, 5, 6).
Then I have the second table with the bookings of these rooms.
I have to make an expression subtracting the rooms already booked from the first list
adding the condition about the dates (check-in and check-out) inputed in the second list and that the user is adding in the form .
Thanks
Hi @SviluppoHW
Have you checked out the documentation on Lists
For sure, but I didn't come up with it...
This is my expression:
Select(Rooms[IDRoom], true)
-
Select(Bookings[IDRoom],
AND(Bookings[IDRoom]=[_THISROW].[IDRoom],
[_THISROW].[EndDate] > [StartDate],
[_THISROW].[StartDate] < [EndDate])
)
Remove the table reference as shown below:
User | Count |
---|---|
43 | |
27 | |
23 | |
14 | |
12 |