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 with car trips, looking like this:
StartDate StAddress EndDate EndAddress Distance Duration SameTrip
1 15/1/2018 06:56:07 street 1 15/1/2018 07:00:00 street 2 1,5 3,88
2 15/1/2018 07:01:57 street 2 15/1/2018 07:02:57 street 3 1 1 yes
3 15/1/2018 07:03:57 street 3 15/1/2018 07:58:22 street 4 56,9 54,42 yes
4 15/1/2018 17:19:51 street 4 15/1/2018 18:32:31 street 1 57 72,63
I would like to summarize this data into a new table looking like this (most important to sum distance and duration, end address is not the most important part but nice if it works):
StartDate StAddress EndDate EndAddress Distance DurationTrip SameTrip
1 15/1/2018 06:56:07 street 1 15/1/2018 07:58:22 street 4 59,4 59,3
4 15/1/2018 17:19:51 street 4 15/1/2018 18:32:31 street 1 57 72,63
I am trying to get the indexes of the rows that have SameTrip = "yes" and the same date to be the equal, but it seems hard when a trip has more than 2 rows.
Does anyone have an idea to fix this in DAX code? (some of the columns of this dataset are not available in the power query so it has to be in DAX)
Shelly
I just now found a way to get a new index column that gives the same index to rows that belong to the same trip. But it is not pretty, so if anyone has a better solution I am very happy to hear.
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 |
---|---|
40 | |
20 | |
19 | |
15 | |
15 |
User | Count |
---|---|
47 | |
28 | |
25 | |
17 | |
17 |