Forum Discussion
Fleet Tracking
Hi pykie80,
Thanks for reaching out in Microsoft Community Forum.
Please follow below to resolve the error;
1.Group the IVMS data by time intervals (e.g., hourly or 30-minute slots) to simplify large datasets in Power BI.
2.Use DAX measures to identify overlapping usage periods between vehicles (e.g., by comparing start and end times).
3.Create visuals like stacked bar charts for usage trends, heatmaps for concurrent usage, and a matrix table for time slot-based vehicle tracking with filters for Group, Registration, and Date.
Please continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.
Super UserHi pykie80
Fleet utilization combined with user accountability is a great way to spot inefficiencies or overlaps in scheduling.
1. Count how many users drove each vehicle
Use a simple DAX measure like this:
UserCount = CALCULATE(DISTINCTCOUNT(Fleet[UserID]), ALLEXCEPT(Fleet, Fleet[VehicleID]))
You can place this in a matrix visual with Vehicle ID on rows to get the per-vehicle count.
2. Detect overlapping usage of the same vehicle
To identify overlaps, you'll need to compare each row's time window against others for the same vehicle.
You can use Power Query to do this:
-
Merge the Fleet table to itself on VehicleID
-
Then add a custom column with logic like:
(Start1 < End2) and (End1 > Start2)
This helps flag cases where two users' usage windows intersect for the same vehicle. You can add a flag or even list overlapping user pairs.
3. Filter by selected user
Add a slicer on UserID. When applied, the visuals will adjust to show overlaps or usage count for that user only.
Optionally, you can create a custom measure that returns a warning or highlight when the selected user overlaps with someone else for a vehicle.