Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |