Days Overnight Count

Question

I have a table with Name, Arrival Date, Departure Date.Examples would be:Jim Smith&nbsp; &nbsp; &nbsp; &nbsp;8/1/18&nbsp; &nbsp; &nbsp; &nbsp;8/5/18John Doe&nbsp; &nbsp; &nbsp; &nbsp;8/1/18&nbsp; &nbsp; &nbsp; &nbsp;8/2/18Sally Jones&nbsp; &nbsp; &nbsp;8/2/18&nbsp; &nbsp; &nbsp; &nbsp;8/2/18Billy Bob&nbsp; &nbsp; &nbsp; &nbsp; 8/7/18&nbsp; &nbsp; &nbsp; &nbsp; 8/9/18&nbsp;I can calculate the number of days someone stays. But how do I get a chart that shows how many people were there on a given day and even show days where no one stayed. So above information would give me this:&nbsp;8/1/18&nbsp; &nbsp; 28/2/18&nbsp; &nbsp; 18/3/18&nbsp; &nbsp; 18/4/18&nbsp; &nbsp; 18/5/18&nbsp; &nbsp; 08/6/18&nbsp; &nbsp; 08/7/18&nbsp; &nbsp; 18/8/18&nbsp; &nbsp; 1&nbsp;

anonymous · Accepted Answer

Hi kattlees&nbsp;For this, you need to expand the values for the date range for each stay. Say for ex, you should have 5 records for Jim , one for each day of his staying.&nbsp;Recently, provided the solution for this scenrio, you can refer the solution here.&nbsp;https://community.powerbi.com/t5/Desktop/chart-with-start-and-end-date/m-p/484219#M225455&nbsp;&nbsp;ThanksRaj

Forum Discussion

Days Overnight Count

1 Reply

Related content

Counting nulls

Day Count Measure

Count per day

Count Operating Days

Count calls per day and week