Days Overnight Count

[kattlees]

I have a table with Name, Arrival Date, Departure Date.

Examples would be:

Jim Smith       8/1/18       8/5/18

John Doe       8/1/18       8/2/18

Sally Jones     8/2/18       8/2/18

Billy Bob        8/7/18        8/9/18

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:

8/1/18    2

8/2/18    1

8/3/18    1

8/4/18    1

8/5/18    0

8/6/18    0

8/7/18    1

8/8/18    1

[Anonymous · Accepted solution]

Hi @kattlees

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.

Recently, provided the solution for this scenrio, you can refer the solution here.

https://community.powerbi.com/t5/Desktop/chart-with-start-and-end-date/m-p/484219#M225455

Thanks

Raj