Hotel occupancy rates help???

[Yiannis_CFO]

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

[MFelix]

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
MFelix

[Yiannis_CFO]

hello 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????

[MFelix]

If 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

[Yiannis_CFO]

unfortunately it continues to give me as result the annual total percentage and not the monthly one....(((

I cannot understand what is going wrong

[MFelix]

What column are you using for month context?

[Yiannis_CFO]

[MFelix · Accepted solution]

You should create a measure not a calculated column.

Using a colum it will sum values of percentage and not calculate percentage.

Regards
Mfelix

[Yiannis_CFO]

Thanks a lot ! now i understood 

I thought that it could be done on table and i lost a lot of time

Once again Thanks!