Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi every body,
Im trying to use measures with DAX to obtain the max number of travels(which are my rows) within 2 hours in my dataset that can also be interpreted as max busy vehicles
what i can think so far is the next:
Time |
01/01/2024 12:25:00 AM |
01/01/2024 12:25:00 AM |
01/01/2024 12:25:00 AM |
01/01/2024 12:25:00 AM |
01/01/2024 12:25:00 AM |
01/01/2024 12:25:00 AM |
01/01/2024 12:25:00 AM |
01/01/2024 12:50:00 AM |
01/01/2024 03:00:00 AM |
01/01/2024 05:45:00 AM |
01/01/2024 05:45:00 AM |
01/01/2024 05:45:00 AM |
01/01/2024 06:00:00 AM |
01/01/2024 06:00:00 AM |
01/01/2024 06:00:00 AM |
01/01/2024 06:00:00 AM |
01/01/2024 09:00:00 AM |
01/01/2024 12:00:00 PM |
01/01/2024 12:00:00 PM |
01/01/2024 12:00:00 PM |
01/01/2024 12:40:00 PM |
01/01/2024 02:00:00 PM |
01/01/2024 03:30:00 PM |
01/01/2024 07:00:00 PM |
02/01/2024 12:50:00 AM |
02/01/2024 01:00:00 AM |
02/01/2024 06:20:00 AM |
02/01/2024 08:50:00 AM |
02/01/2024 08:50:00 AM |
02/01/2024 12:25:00 PM |
02/01/2024 12:25:00 PM |
02/01/2024 12:25:00 PM |
02/01/2024 12:25:00 PM |
02/01/2024 12:25:00 PM |
02/01/2024 12:25:00 PM |
02/01/2024 12:25:00 PM |
02/01/2024 12:25:00 PM |
02/01/2024 12:25:00 PM |
02/01/2024 12:25:00 PM |
02/01/2024 12:25:00 PM |
02/01/2024 12:25:00 PM |
02/01/2024 12:25:00 PM |
02/01/2024 06:15:00 PM |
02/01/2024 06:15:00 PM |
02/01/2024 06:15:00 PM |
02/01/2024 06:15:00 PM |
02/01/2024 06:15:00 PM |
02/01/2024 06:15:00 PM |
02/01/2024 06:15:00 PM |
02/01/2024 10:00:00 PM |
02/01/2024 10:00:00 PM |
02/01/2024 11:00:00 PM |
02/01/2024 11:30:00 PM |
03/01/2024 12:25:00 AM |
03/01/2024 12:25:00 AM |
03/01/2024 12:25:00 AM |
03/01/2024 12:25:00 AM |
03/01/2024 12:25:00 AM |
03/01/2024 12:25:00 AM |
03/01/2024 12:25:00 AM |
03/01/2024 12:25:00 AM |
03/01/2024 12:25:00 AM |
03/01/2024 12:25:00 AM |
03/01/2024 12:25:00 AM |
03/01/2024 12:25:00 AM |
03/01/2024 12:25:00 AM |
03/01/2024 12:25:00 AM |
03/01/2024 12:25:00 AM |
03/01/2024 12:25:00 AM |
03/01/2024 12:25:00 AM |
03/01/2024 12:25:00 AM |
03/01/2024 12:25:00 AM |
03/01/2024 12:25:00 AM |
03/01/2024 12:25:00 AM |
03/01/2024 12:25:00 AM |
03/01/2024 12:50:00 AM |
03/01/2024 01:00:00 AM |
03/01/2024 06:20:00 AM |
03/01/2024 08:45:00 AM |
03/01/2024 08:45:00 AM |
03/01/2024 08:45:00 AM |
03/01/2024 08:45:00 AM |
03/01/2024 08:45:00 AM |
03/01/2024 10:30:00 AM |
03/01/2024 06:15:00 PM |
03/01/2024 06:15:00 PM |
03/01/2024 06:15:00 PM |
03/01/2024 06:15:00 PM |
03/01/2024 06:15:00 PM |
03/01/2024 06:15:00 PM |
03/01/2024 06:15:00 PM |
03/01/2024 06:15:00 PM |
03/01/2024 06:15:00 PM |
03/01/2024 06:15:00 PM |
03/01/2024 10:30:00 PM |
03/01/2024 10:30:00 PM |
03/01/2024 10:30:00 PM |
03/01/2024 11:00:00 PM |
03/01/2024 11:00:00 PM |
Solved! Go to Solution.
somehow bumped with what I wanted (I believe cant understand my own solution at all).
Here is the solution to the groupby but something weird is making my max here 26 instead of 25, i believe has to be with rounding 1/12 (the 2 hours) spoiling the the > and turning similar to >=,
then I have my full solution:
Hi @metalfortune, give this a try, and if you encounter any issues, let me know.
Create a calculated column:
TimeBucket = INT(HOUR([Time])/2) + INT(MINUTE([Time])/120) + DATEVALUE([Time])
Then, create a measure:
MaxBusyVehicles =
CALCULATE(
MAXX(
SUMMARIZE(
data,
[TimeBucket],
"VehicleCount", COUNTROWS(data)
),
[VehicleCount]
)
)
Did I answer your question? If so, please mark my post as the solution! ✔️
Your Kudos are much appreciated! Proud to be a Solution Supplier!
somehow bumped with what I wanted (I believe cant understand my own solution at all).
Here is the solution to the groupby but something weird is making my max here 26 instead of 25, i believe has to be with rounding 1/12 (the 2 hours) spoiling the the > and turning similar to >=,
then I have my full solution:
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
24 | |
19 | |
14 | |
10 | |
7 |