Forum Discussion
Solved
Hotel occupancy rates help???
hello,
I would kindly ask someone's help as i am confused....
I used the following formula to receive the average rate per month on my matix but it gives me the same annual value for all months ......
DIVIDE(sumx('Table';'Column'[1]);sumx('Table';'Column'[2]);0)
column 1 is sold rooms per day
column 2 is available rooms per day
what am i doing wrong????
thanks in advance
- You should create a measure not a calculated column.
Using a colum it will sum values of percentage and not calculate percentage.
Regards
Mfelix
8 Replies
- MFelix
Super User
Hi Yiannis_CFO,
are your tables related by a calendar table or similar?
You should have the tables related by calendar table and the use the measure.:
DIVIDE(sum('Table'[Column'1]);sum('Table'[Column'2]);0)
Use the month on calendar table for your visual.
Regards
MFelixhello Mfelix,
in the same table there is column with AUTOCALENDAER from 01/01/2017 up to 31/12/2018
i need to create another table????
- MFelixIf the columns are on the same table no need to create a calendar. Use the formula as I wrote and check if it works.
Regards
MFelix
