Forum Discussion
Solved
Days Overnight Count
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 ...
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
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