I have an issue I manage a carpark space which runs 24/7. How do I, in Power BI calculate the number of vehicles in the carpark at various times throughout the day at an interval of 5 minutes. I have 2 types of users, Members & Visitors.
I also need to set a capacity for the carpark at "1000" spaces, and then need to calculate the capacity at given intervals
Location | RECEIPT NO | DEPARTMENT | SALES ASSISTANT | Barrier Code | CATEGORY | SUB CATEGORY | Qty | In Date | In Time | Out Date | Out Time |
Location 1 | 9.75E+18 | APM | PAID | T3-L1-E6 | T3-L1-X7 | VISITOR | NORMAL VISITOR | 1 | Saturday, July 24, 2021 | ####### | Saturday, July 24, 2021 | ####### |
Location 1 | 9.75E+18 | APM | PAID | T3-L1-E6 | T3-L1-X6 | VISITOR | NORMAL VISITOR | 1 | Saturday, July 24, 2021 | ####### | Saturday, July 24, 2021 | ####### |
Location 2 | 9.75E+18 | APM | PAID | T3-L3-E3 | T3-L3-X6 | VISITOR | NORMAL VISITOR | 1 | Friday, July 23, 2021 | ####### | Saturday, July 24, 2021 | ####### |
Location 2 | 9.75E+18 | APM | PAID | T3-L3-E3 | T3-L3-X6 | VISITOR | NORMAL VISITOR | 1 | Wednesday, July 21, 2021 | ####### | Saturday, July 24, 2021 | ####### |
Location 1 | 9.75E+18 | CASH OFFICE | FREE | T3-L1-E4 | T3-L1-X2 | MEMBER | MUNA AHMED AL MARZOUQI-00000491 | 1 | Tuesday, June 1, 2021 | ####### | Sunday, July 11, 2021 | ####### |
Location 1 | 9.75E+18 | CASH OFFICE | FREE | T3-L1-E2 | T3-L1-X3 | MEMBER | MOUSA YOUSEF SHATAT-00000008 | 1 | Thursday, July 8, 2021 | ####### | Sunday, July 11, 2021 | ####### |
Location 3 | 9.75E+18 | CASH OFFICE | FREE | T3-L2-E2 | T3-L2-X2 | MEMBER | AMER SAYED MOHD AL HASHIMI-00000177 | 1 | Saturday, July 10, 2021 | ####### | Sunday, July 11, 2021 | ####### |
Location 3 | 9.75E+18 | CASH OFFICE | FREE | T3-L2-E2 | T3-L2-X2 | MEMBER | ALIA ABDULRAHMAN OBAID-00004797 | 1 | Sunday, July 25, 2021 | ####### | Sunday, July 25, 2021 | ####### |
I hope someone can help,
Regards,
Nadeem
