Counting days between selection in calendar

[#1]

Hi, i am new to this. I am building a pivot table to calculate occupation in an hotel between 2 dates. I already have a pivot table with a column with number of nights sold for every room and also a calendar object to filter the data in the table by dates. I need to add another column that shows the number of days between the 2 days selected on the calendar (set to multiple values), so I can calculate ocuppation (# of nights/# of days selected)*100%).

Any ideas?

[stephencredmond · Accepted solution]

Might be simplistic but does:

Count(Distinct Date_Key)

[whatever your key for the calendar is called]

Regards,

Stephen

[#3]

Thanks that worked very good.