Hello guys,
I'm stucked right here but i believe also that something is missing and don't what.
I'm sure any of you can help me.
I have a table (sum report) that shows me for each day, beside other fields, reservation ID, Day, room name, value, etc.
I have another table that gives me for each room name the total of rooms. By the way, this table is made of the first one, only grouped.
I have already made a report wich shows me the room name, number of rooms booked and a total value, by a certain day.
What i need to know is the total rooms for each type of room, so i can get the % occupancy, for that particular day, week or month.
I've done this but of course it's not working:
Qty Rooms by types = SUMX('Summary Reports Room Table', 'Summary Reports Room Table'[Rooms], FILTER('Summary Reports', 'Summary Reports'[Location_RoomType]))
The tables are related by the field location room type.
Thank you very much for your help
Pedro
