Hi,
Based on the table below, I'm trying to create a calculated measure that returns the Deviation value for the MIN value from the column TimeAtLocation for the rows that have the same PathIdent-Departure value as the present row. The wanted result is in the last column of the table.
I've tried combinations of CALCULATE and FILTER but have not been able to get the correct result. Any help would be much appreciated!
//Caj
<tbody>
</tbody>
Based on the table below, I'm trying to create a calculated measure that returns the Deviation value for the MIN value from the column TimeAtLocation for the rows that have the same PathIdent-Departure value as the present row. The wanted result is in the last column of the table.
I've tried combinations of CALCULATE and FILTER but have not been able to get the correct result. Any help would be much appreciated!
//Caj
TimeAtLocation | Deviation | PathIdent-Departure | Wanted result |
2012-04-04 16:34 | -11 | 41612 - 2012-04-04 16:34:00 | -11 |
2012-04-04 16:44 | 1 | 41612 - 2012-04-04 16:34:00 | -11 |
2012-04-04 16:57 | 2 | 41612 - 2012-04-04 16:34:00 | -11 |
2012-04-04 17:08 | 1 | 41612 - 2012-04-04 16:34:00 | -11 |
2012-04-04 17:20 | 1 | 41612 - 2012-04-04 16:34:00 | -11 |
2012-04-04 17:32 | 3 | 41612 - 2012-04-04 16:34:00 | -11 |
2012-05-11 16:34 | -16 | 41612 - 2012-05-11 16:34:00 | -16 |
2012-05-11 16:44 | 2 | 41612 - 2012-05-11 16:34:00 | -16 |
2012-05-11 16:57 | 4 | 41612 - 2012-05-11 16:34:00 | -16 |
2012-05-11 17:08 | 3 | 41612 - 2012-05-11 16:34:00 | -16 |
2012-05-11 17:20 | 1 | 41612 - 2012-05-11 16:34:00 | -16 |
2012-05-11 17:32 | 1 | 41612 - 2012-05-11 16:34:00 | -16 |
2012-05-11 17:43 | 41612 - 2012-05-11 16:34:00 | -16 | |
2012-05-11 17:50 | 41612 - 2012-05-11 16:34:00 | -16 |
<tbody>
</tbody>