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.
Hi
I have a table of bus stops 'BusStops' where every row is a stop on a specific station
Columns:
'HourAtStop' which is the hour when the bus is in the station (6,7,8...)
'Start/End' which tell if is the bus is 'starting', 'finishing' or 'PassingBy'.
i want to make a measure that will tell me what is The busiest hour on the station, and how many stops there is on this hour in this station.
Thanks
Hi @AvnerBZ ,
Can you please share some screenshots around sample data and the desired output?
Thanks,
Pragati
BusStops | ||||
StopID | LineNumber | HourAtStop | BusyHourAtStop | DepBusyHour |
111 | 19 | 7 | 7 | 4 |
111 | 19 | 7 | 7 | 4 |
111 | 19 | 8 | 7 | 4 |
111 | 17 | 7 | 7 | 4 |
111 | 17 | 7 | 7 | 4 |
112 | 23 | 10 | 10 | 3 |
112 | 23 | 10 | 10 | 3 |
112 | 24 | 10 | 10 | 3 |
112 | 24 | 11 | 10 | 3 |
112 | 25 | 11 | 10 | 3 |
112 | 25 | 12 | 10 | 3 |
'BusyHourAtStop' and 'DepBusyHour' are the desired output
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 |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
46 | |
31 | |
30 | |
18 | |
18 |