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.
Tengo dos mesas.
Primera tabla
Nombre del encabezado | Unidad Base | Horas de arranque del motor | Detener las horas del motor |
A | HAJW210HKMG679924 | 10 | 30 |
A | HAJSR26VTNG680048 | 980.9 | 1005.8 |
A | HAJSR26HKMG679915 | 947.8 | 974.3 |
B | HAJSR26HLMG679906 | 739.4 | 756.1 |
B | HAJW210HKMG679924 | 1234.5 | 1283.7 |
B | HAJSR26VTNG680048 | 1006.9 | 1051.7 |
C | HAJSR26HKMG679915 | 789.5 | 875.8 |
C | HAJW210VVNG680521 | 1.5 | 5.1 |
C | HAJW210HKMG679924 | 1284.1 | 1333.5 |
D | HAJSR22HKMG679922 | 254 | 270 |
D | HAJSR22HPMG679921 | 290 | 310 |
E | HAJSR22HPMG679921 | 290 | 310 |
E | HAJSR22HPMG679921 | 290 | 310 |
A | HAJW210HKMG679924 | 200 | 230
|
Segunda tabla
vin17 | ENG_HOURS | gps_timestamp | Promedio de AMBIENT_AIR_TEMPERATURE |
HAJW210HKMG679924 | 10 | 7/29/2021 15:59 | 45 |
HAJW210HKMG679924 | 20 | 7/29/2021 16:00 | 45 |
HAJW210HKMG679924 | 30 | 7/29/2021 16:02 | 45 |
HAJW210HKMG679924 | 40 | 7/29/2021 16:03 | 44 |
HAJSR26VTNG680048 | 50 | 7/29/2021 16:04 | 42 |
HAJSR26VTNG680048 | 60 | 7/29/2021 16:05 | 42 |
HAJSR26VTNG680048 | 70 | 7/29/2021 16:06 | 43 |
HAJW210HKMG679924 | 80 | 7/29/2021 16:07 | 44 |
HAJW210HKMG679924 | 90 | 7/29/2021 16:08 | 44 |
HAJW210HKMG679924 | 100 | 7/29/2021 16:09 | 45 |
HAJW210HKMG679924 | 110 | 7/29/2021 16:10 | 45 |
HAJW210HKMG679924 | 120 | 7/29/2021 16:11 | 46 |
HAJW210HKMG679924 | 130 | 7/29/2021 16:12 | 46 |
HAJW210HKMG679924 | 140 | 7/29/2021 16:13 | 46 |
HAJW210HKMG679924 | 150 | 7/29/2021 16:14 | 46 |
HAJW210HKMG679924 | 160 | 7/29/2021 16:15 | 46 |
HAJW210HKMG679924 | 170 | 7/29/2021 16:16 | 46 |
HAJW210HKMG679924 | 180 | 7/29/2021 16:18 | 47 |
HAJW210HKMG679924 | 190 | 7/29/2021 16:19 | 47 |
HAJW210HKMG679924 | 200 | 7/29/2021 16:20 | 47 |
HAJW210HKMG679924 | 210 | 7/29/2021 16:23 | 48 |
HAJW210HKMG679924 | 220 | 7/29/2021 16:26 | 49 |
HAJW210HKMG679924 | 230 | 8/5/2021 14:44 | 27 |
HAJSR26HLMG679906 | 229.8 | 8/6/2021 16:56 | 49 |
HAJSR26HLMG679906 | 229.8 | 8/6/2021 16:57 | 49 |
HAJSR26HLMG679906 | 229.8 | 8/6/2021 16:58 | 50 |
HAJSR26HLMG679906 | 229.8 | 8/6/2021 16:59 | 51 |
HAJSR26HLMG679906 | 229.9 | 8/6/2021 17:00 | 51 |
HAJSR26HLMG679906 | 229.9 | 8/6/2021 17:01 | 51 |
HAJSR26HLMG679906 | 229.9 | 8/6/2021 17:02 | 49 |
HAJSR26HLMG679906 | 229.9 | 8/6/2021 17:03 | 48 |
HAJSR26HLMG679906 | 229.9 | 8/6/2021 17:04 | 48 |
HAJSR26HLMG679906 | 229.9 | 8/6/2021 17:05 | 48 |
HAJSR26HLMG679906 | 230 | 8/6/2021 17:06 | 49 |
HAJSR26HLMG679906 | 230 | 8/6/2021 17:07 | 48 |
HAJSR26HLMG679906 | 230 | 8/6/2021 17:08 | 48 |
HAJSR26HLMG679906 | 230 | 8/6/2021 17:09 | 46 |
HAJSR26HLMG679906 | 230 | 8/6/2021 17:10 | 45 |
HAJSR26HLMG679906 | 230 | 8/6/2021 17:11 | 47 |
HAJSR26HLMG679906 | 230.1 | 8/6/2021 17:12 | 49 |
HAJSR26HLMG679906 | 230.1 | 8/6/2021 17:13 | 51 |
HAJSR26HLMG679906 | 230.1 | 8/6/2021 17:14 | 52 |
HAJSR26HLMG679906 | 230.1 | 8/6/2021 17:15 | 54 |
HAJSR26HLMG679906 | 230.1 | 8/6/2021 17:17 | 56 |
HAJSR26HLMG679906 | 230.2 | 8/6/2021 17:19 | 57 |
HAJSR26HLMG679906 | 230.2 | 8/6/2021 17:21 | 57 |
HAJSR26HLMG679906 | 230.2 | 8/6/2021 17:22 | 57 |
HAJSR26HLMG679906 | 230.2 | 8/6/2021 17:23 | 58 |
HAJSR26HLMG679906 | 230.2 | 8/6/2021 17:24 | 58 |
HAJSR26HLMG679906 | 230.3 | 8/6/2021 17:26 | 58 |
HAJSR26HLMG679906 | 230.3 | 8/6/2021 17:30 | 58 |
HAJSR26HLMG679906 | 230.4 | 8/6/2021 17:31 | 58 |
HAJSR26HLMG679906 | 230.4 | 8/6/2021 17:33 | 58 |
HAJSR26HLMG679906 | 230.4 | 8/6/2021 17:34 | 57 |
HAJSR26HLMG679906 | 230.4 | 8/6/2021 17:35 | 58 |
HAJSR26HLMG679906 | 230.5 | 8/6/2021 17:37 | 58 |
HAJSR26HLMG679906 | 230.5 | 8/6/2021 17:38 | 58 |
HAJSR26HLMG679906 | 230.5 | 8/6/2021 17:39 | 57 |
HAJSR26HLMG679906 | 230.5 | 8/6/2021 17:40 | 57 |
HAJSR26HLMG679906 | 230.5 | 8/6/2021 17:41 | 57 |
HAJSR26HLMG679906 | 230.5 | 8/6/2021 17:42 | 57 |
HAJSR26HLMG679906 | 230.6 | 8/6/2021 17:43 | 58 |
HAJSR26HLMG679906 | 230.6 | 8/6/2021 17:44 | 57 |
¿Cómo puedo buscar el nombre del encabezado de la Tabla uno a la Tabla dos, donde las horas del motor caen entre las horas del motor de arranque y las horas del motor de parada para cada unidad base?
@rahul632soni , nuevo ejemplo de columna
MAxx(filter(Tabla1, Tabla1[Unidad base] = Tabla2[Ven17] && Hora(Tabla2[gps_timestamp]) >= Tabla1[Horas de arranque del motor] && Hora(Tabla2[gps_timestamp]) <= Tabla1[Fin de horas del motor] ), [Nombre del encabezado])
Consulte 4 formas (Related, RelatedTable, LookUpValue, SumX/Minx/Maxx con filtro) para copiar datos de una tabla a otra
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
@amitchandak Eh
¿Cómo podemos comparar la marca de tiempo y las horas del motor, tenemos horas del motor para comparar de ambas tablas.
¿No podemos usar simplemente eso de la Tabla 1?
Saludos
Rahul
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 |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
1 |