Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
jav1985
Frequent Visitor

calculo tiempo encedido auto

‎09-23-2023 08:12 AM

Hola a todos, les pido su orientación. estoy trabajando con power bi y DAX. Tengo una tabla que tiene datos de encendido y apagado de vehículos y necesito calcular los periodos de tiempo en que los vehículo estan prendidos. La tabla registra el estado cada X tiempo, por lo que se puede repetir tanto el estado de IgnitionOnTime e IgnitionOffTime, los valores claramente tienen su timeStamp. Entonces, necesito poder calcular el periodo de tiempo que un vehículo esta prendido. lo que estoy intentado de realizar es detectar el cambio del ultimo  IgnitionOnTime al IgnitionOffTime o de IgnitionOffTime a IgnitionOnTime, y así poder sacar la diferencia del tiempo y obtener el perido de encedido. La tabla tiene registrado varios vehículos diferentes y los espacios en blanco IgnitionOnTime e IgnitionOffTime son por que el equipo esta apagado.

2023_09_23_12_07_50_Libro2_Excel.png

 

Labels:
Message 1 of 3
131 Views
0
2 REPLIES 2
jav1985
Frequent Visitor

‎09-25-2023 04:45 AM

ok,

 

 

ID;GPSTime;name;IgnitionOnTime;IgnitionOffTime
14074738;9/12/2023 0:00;CDH92;;
14074739;9/12/2023 0:00;CDH60;;
14158152;9/12/2023 0:01;EX374;;
14075154;9/12/2023 0:01;CDH65;IgnitionOnTime;
14083481;9/12/2023 0:01;OP038;;IgnitionOffTime
14082533;9/12/2023 0:01;EX404;;
14074871;9/12/2023 0:01;CDH57;IgnitionOnTime;
14082534;9/12/2023 0:01;EX404;;
14074746;9/12/2023 0:01;CDH85;;
14158153;9/12/2023 0:02;EX374;IgnitionOnTime;
14074752;9/12/2023 0:02;CDH85;;
14074779;9/12/2023 0:03;CDH51;;
14074780;9/12/2023 0:03;CDH51;;
14074920;9/12/2023 0:03;CDH47;IgnitionOnTime;
14074781;9/12/2023 0:03;CDH51;;
14075354;9/12/2023 0:03;EX321;;IgnitionOffTime
14075355;9/12/2023 0:03;EX321;IgnitionOnTime;
14079132;9/12/2023 0:03;MA059;;IgnitionOffTime
14074766;9/12/2023 0:03;CDH67;IgnitionOnTime;
14074770;9/12/2023 0:03;CDH68;;
14074774;9/12/2023 0:03;MA085;;
14077781;9/12/2023 0:04;EX963;;IgnitionOffTime
14074823;9/12/2023 0:04;PHK16;;IgnitionOffTime
14075158;9/12/2023 0:04;CDH65;;IgnitionOffTime
14075159;9/12/2023 0:04;CDH65;IgnitionOnTime;
14074824;9/12/2023 0:04;PHK16;IgnitionOnTime;
14074782;9/12/2023 0:04;CDH48;;
14074783;9/12/2023 0:04;CDH73;;
14076748;9/12/2023 0:04;EX544;;
14074792;9/12/2023 0:04;CDH61;;
14075107;9/12/2023 0:05;CDH61;;
14074794;9/12/2023 0:05;MA085;;
14074795;9/12/2023 0:05;CDH60;;
14076749;9/12/2023 0:05;EX544;;
14078390;9/12/2023 0:05;OP061;;
14175878;9/12/2023 0:05;EX964;IgnitionOnTime;
14074800;9/12/2023 0:05;CDH67;;
14175879;9/12/2023 0:05;EX964;;IgnitionOffTime
14074801;9/12/2023 0:05;CDH55;;
14076750;9/12/2023 0:05;EX544;;
14074803;9/12/2023 0:05;CDH67;;
14077511;9/12/2023 0:05;EX600;;IgnitionOffTime
14077512;9/12/2023 0:05;EX600;IgnitionOnTime;
14074812;9/12/2023 0:05;CDH67;;IgnitionOffTime
14077877;9/12/2023 0:06;EX600;;IgnitionOffTime
14077960;9/12/2023 0:06;EX600;IgnitionOnTime;
14076751;9/12/2023 0:06;EX544;;
14074861;9/12/2023 0:06;CDH73;;IgnitionOffTime
14074874;9/12/2023 0:06;CDH73;IgnitionOnTime;
14076752;9/12/2023 0:06;EX544;;
14074836;9/12/2023 0:07;CDH92;;
14074945;9/12/2023 0:07;CDH72;IgnitionOnTime;
14079253;9/12/2023 0:07;OP161;;
14074834;9/12/2023 0:07;CDH48;;
14075060;9/12/2023 0:07;CDH53;IgnitionOnTime;
14074946;9/12/2023 0:07;CDH72;;IgnitionOffTime
14074947;9/12/2023 0:07;CDH72;IgnitionOnTime;
14074860;9/12/2023 0:07;CDH49;;
14158154;9/12/2023 0:07;EX374;;IgnitionOffTime
14074870;9/12/2023 0:08;CDH62;;
14074926;9/12/2023 0:08;CDH51;;IgnitionOffTime
14074927;9/12/2023 0:08;CDH51;;
14074922;9/12/2023 0:08;CDH62;;IgnitionOffTime
14074935;9/12/2023 0:08;CDH62;IgnitionOnTime;
14074936;9/12/2023 0:08;CDH62;;
14076753;9/12/2023 0:08;EX544;;
14074932;9/12/2023 0:08;CDH51;IgnitionOnTime;
14074878;9/12/2023 0:08;CDH48;;
14074934;9/12/2023 0:08;CDH51;;
14076754;9/12/2023 0:08;EX544;;
14074896;9/12/2023 0:09;CDH48;;
14075062;9/12/2023 0:09;CDH53;;IgnitionOffTime
14075063;9/12/2023 0:09;CDH53;IgnitionOnTime;
14074938;9/12/2023 0:09;CDH62;;
14074907;9/12/2023 0:09;CDH48;;
14074939;9/12/2023 0:09;CDH62;;
14074908;9/12/2023 0:09;CDH48;;
14075064;9/12/2023 0:09;CDH53;;IgnitionOffTime
14075065;9/12/2023 0:09;CDH53;IgnitionOnTime;
14079254;9/12/2023 0:09;OP161;;
14074921;9/12/2023 0:09;CDH48;;
14075066;9/12/2023 0:09;CDH53;;IgnitionOffTime
14074924;9/12/2023 0:10;CDH48;;
14075067;9/12/2023 0:10;CDH53;IgnitionOnTime;
14074957;9/12/2023 0:10;PHK16;;IgnitionOffTime
14075068;9/12/2023 0:10;CDH53;;IgnitionOffTime
14075069;9/12/2023 0:10;CDH53;IgnitionOnTime;
14075070;9/12/2023 0:10;CDH53;;IgnitionOffTime
14075071;9/12/2023 0:10;CDH53;IgnitionOnTime;
14074959;9/12/2023 0:10;PHK16;IgnitionOnTime;
14079255;9/12/2023 0:10;OP161;;
14075072;9/12/2023 0:10;CDH53;;IgnitionOffTime
14075073;9/12/2023 0:10;CDH53;IgnitionOnTime;
14075074;9/12/2023 0:10;CDH53;;IgnitionOffTime
14075075;9/12/2023 0:10;CDH53;IgnitionOnTime;
14074967;9/12/2023 0:10;CDH55;;
14075076;9/12/2023 0:11;CDH53;;IgnitionOffTime
14075077;9/12/2023 0:11;CDH53;IgnitionOnTime;
14074952;9/12/2023 0:11;CDH85;;
14075078;9/12/2023 0:11;CDH53;;
14079256;9/12/2023 0:11;OP161;;
14075208;9/12/2023 0:11;CDH74;IgnitionOnTime;
14075079;9/12/2023 0:11;CDH53;;IgnitionOffTime
14075209;9/12/2023 0:11;CDH74;;IgnitionOffTime
14074966;9/12/2023 0:11;CDH48;;
14074970;9/12/2023 0:11;MA085;;
14078392;9/12/2023 0:12;OP061;;
14118254;9/12/2023 0:12;EX596;;
14074998;9/12/2023 0:12;CDH46;;IgnitionOffTime
14075007;9/12/2023 0:12;CDH46;IgnitionOnTime;
14075023;9/12/2023 0:12;CDH46;;IgnitionOffTime
14075097;9/12/2023 0:12;CDH46;IgnitionOnTime;
14075080;9/12/2023 0:12;CDH53;IgnitionOnTime;
14078393;9/12/2023 0:13;OP061;;IgnitionOffTime
14075081;9/12/2023 0:13;CDH53;;IgnitionOffTime
14075004;9/12/2023 0:13;CDH85;;
14075003;9/12/2023 0:13;CDH60;;
14078394;9/12/2023 0:13;OP061;IgnitionOnTime;
14075161;9/12/2023 0:13;CDH65;;
14082541;9/12/2023 0:13;EX404;;
14075014;9/12/2023 0:13;CDH85;;
14075110;9/12/2023 0:13;CDH61;;
14075022;9/12/2023 0:13;CDH92;;
14075192;9/12/2023 0:13;CDH56;IgnitionOnTime;
14082542;9/12/2023 0:14;EX404;;
14077291;9/12/2023 0:14;EX369;;
14075045;9/12/2023 0:14;CDH85;;
14098745;9/12/2023 0:14;CDH52;;
14075111;9/12/2023 0:14;CDH61;;
14079257;9/12/2023 0:15;OP161;;
14075129;9/12/2023 0:15;CDH48;;IgnitionOffTime
14075193;9/12/2023 0:15;CDH56;;IgnitionOffTime
14075134;9/12/2023 0:15;CDH48;IgnitionOnTime;
14077292;9/12/2023 0:15;EX369;;
14075114;9/12/2023 0:15;CDH61;;
14075357;9/12/2023 0:15;EX321;;
14077295;9/12/2023 0:15;EX369;;
14075106;9/12/2023 0:16;CDH60;;IgnitionOffTime
14086835;9/12/2023 0:17;EX240;IgnitionOnTime;
14075124;9/12/2023 0:17;PHK16;;IgnitionOffTime
14075164;9/12/2023 0:17;PHK16;IgnitionOnTime;
14082868;9/12/2023 0:17;OP047;;IgnitionOffTime
14082869;9/12/2023 0:17;OP047;IgnitionOnTime;
14078397;9/12/2023 0:18;OP061;;
14078721;9/12/2023 0:18;EX600;;
14075211;9/12/2023 0:19;CDH74;IgnitionOnTime;
14075149;9/12/2023 0:19;CDH55;;IgnitionOffTime
14075177;9/12/2023 0:19;CDH55;IgnitionOnTime;
14075212;9/12/2023 0:19;CDH74;;IgnitionOffTime
14075147;9/12/2023 0:19;CDH73;;IgnitionOffTime
14086836;9/12/2023 0:19;EX240;;
14075146;9/12/2023 0:20;CDH61;;
14075173;9/12/2023 0:20;CDH73;IgnitionOnTime;
14075150;9/12/2023 0:20;CDH51;;
14075163;9/12/2023 0:20;CDH53;IgnitionOnTime;
14075162;9/12/2023 0:21;CDH47;;
14078399;9/12/2023 0:21;OP061;;
14078722;9/12/2023 0:21;EX600;;
14075165;9/12/2023 0:21;CDH48;;
14075167;9/12/2023 0:21;CDH53;;IgnitionOffTime
14075168;9/12/2023 0:21;CDH62;;
14075169;9/12/2023 0:21;CDH48;;
14078723;9/12/2023 0:21;EX600;;
14075178;9/12/2023 0:22;CDH73;;IgnitionOffTime
14076818;9/12/2023 0:22;EX359;;
14075217;9/12/2023 0:22;CDH73;IgnitionOnTime;
14075171;9/12/2023 0:22;CDH68;;
14075179;9/12/2023 0:22;CDH47;;IgnitionOffTime
14075218;9/12/2023 0:22;CDH73;;
14075172;9/12/2023 0:22;CDH90;IgnitionOnTime;
14075185;9/12/2023 0:22;CDH47;IgnitionOnTime;
14075175;9/12/2023 0:22;CDH49;;IgnitionOffTime
14075176;9/12/2023 0:22;CDH49;IgnitionOnTime;
14075181;9/12/2023 0:22;CDH49;;IgnitionOffTime
14075221;9/12/2023 0:22;CDH49;IgnitionOnTime;
14075174;9/12/2023 0:23;CDH68;;
14075180;9/12/2023 0:23;CDH57;;
14078724;9/12/2023 0:23;EX600;;
14079258;9/12/2023 0:23;OP161;;
14075219;9/12/2023 0:23;CDH73;;
14075183;9/12/2023 0:23;CDH62;;IgnitionOffTime
14104742;9/12/2023 0:23;EX956;IgnitionOnTime;
14075228;9/12/2023 0:23;CDH62;IgnitionOnTime;
14075220;9/12/2023 0:23;CDH73;;
14104743;9/12/2023 0:23;EX956;;IgnitionOffTime
14104744;9/12/2023 0:23;EX956;IgnitionOnTime;
14077296;9/12/2023 0:24;EX369;;
14104745;9/12/2023 0:24;EX956;;
14075184;9/12/2023 0:24;CDH59;IgnitionOnTime;
14077297;9/12/2023 0:24;EX369;;
14075187;9/12/2023 0:24;CDH68;;IgnitionOffTime
14075190;9/12/2023 0:24;CDH47;;IgnitionOffTime
14075215;9/12/2023 0:24;CDH68;IgnitionOnTime;
14079259;9/12/2023 0:24;OP161;;
14075186;9/12/2023 0:24;CDH57;;
14077298;9/12/2023 0:24;EX369;;
14075213;9/12/2023 0:24;CDH47;IgnitionOnTime;
14080858;9/12/2023 0:24;CDH44;IgnitionOnTime;
14080859;9/12/2023 0:25;CDH44;;
14080860;9/12/2023 0:25;CDH44;;
14075189;9/12/2023 0:25;CDH55;;
14078401;9/12/2023 0:25;OP061;;
14080861;9/12/2023 0:25;CDH44;;IgnitionOffTime
14075194;9/12/2023 0:25;CDH59;;
14080862;9/12/2023 0:25;CDH44;IgnitionOnTime;
14104746;9/12/2023 0:25;EX956;;
14075195;9/12/2023 0:25;CDH49;IgnitionOnTime;
14075222;9/12/2023 0:25;CDH49;;IgnitionOffTime
14075224;9/12/2023 0:25;CDH49;IgnitionOnTime;
14075452;9/12/2023 0:25;CDH55;;
14075223;9/12/2023 0:25;PAB06;;IgnitionOffTime
14075201;9/12/2023 0:25;PAB11;;IgnitionOffTime
14075225;9/12/2023 0:26;PAB06;IgnitionOnTime;
14075396;9/12/2023 0:26;PAB11;IgnitionOnTime;
14104747;9/12/2023 0:26;EX956;;IgnitionOffTime
14075200;9/12/2023 0:26;CDH51;;IgnitionOffTime
14075202;9/12/2023 0:26;CDH51;;
14075198;9/12/2023 0:26;CDH90;;IgnitionOffTime
14075453;9/12/2023 0:26;CDH55;;
14075236;9/12/2023 0:26;CDH51;IgnitionOnTime;
14080863;9/12/2023 0:26;CDH44;;IgnitionOffTime
14075199;9/12/2023 0:26;CDH59;;
14075237;9/12/2023 0:26;CDH51;;
14075206;9/12/2023 0:27;CDH57;;IgnitionOffTime
14075207;9/12/2023 0:27;CDH57;IgnitionOnTime;
14075204;9/12/2023 0:27;CDH59;;
14075210;9/12/2023 0:28;CDH59;;
14118645;9/12/2023 0:28;OP011;IgnitionOnTime;
14118646;9/12/2023 0:28;OP011;;IgnitionOffTime
14075214;9/12/2023 0:28;CDH68;IgnitionOnTime;
14079260;9/12/2023 0:28;OP161;;
14079261;9/12/2023 0:28;OP161;;
14075227;9/12/2023 0:28;CDH49;;IgnitionOffTime
14075231;9/12/2023 0:28;CDH49;IgnitionOnTime;
14118647;9/12/2023 0:28;OP011;IgnitionOnTime;
14079262;9/12/2023 0:28;OP161;;
14075216;9/12/2023 0:28;CDH90;IgnitionOnTime;
14077299;9/12/2023 0:29;EX369;;
14077300;9/12/2023 0:29;EX369;;
14075229;9/12/2023 0:29;CDH62;;IgnitionOffTime
14075243;9/12/2023 0:29;CDH62;IgnitionOnTime;
14078725;9/12/2023 0:29;EX600;;
14075226;9/12/2023 0:29;CDH60;IgnitionOnTime;
14075232;9/12/2023 0:29;CDH49;;
14075361;9/12/2023 0:30;EX321;;IgnitionOffTime
14075234;9/12/2023 0:30;CDH49;;
14075235;9/12/2023 0:30;CDH49;;
14081576;9/12/2023 0:30;EX253;IgnitionOnTime;
14081577;9/12/2023 0:30;EX253;;IgnitionOffTime
14079263;9/12/2023 0:31;OP161;;
14075230;9/12/2023 0:31;CDH59;;
14079264;9/12/2023 0:31;OP161;;
14075233;9/12/2023 0:31;CDH51;IgnitionOnTime;
14075238;9/12/2023 0:31;CDH51;;
14081578;9/12/2023 0:31;EX253;IgnitionOnTime;
14075240;9/12/2023 0:31;PAB12;;IgnitionOffTime
14079265;9/12/2023 0:31;OP161;;
14075241;9/12/2023 0:31;PAB12;IgnitionOnTime;
14081579;9/12/2023 0:31;EX253;;
14075239;9/12/2023 0:31;CDH59;;
14176482;9/12/2023 0:31;EX965;;IgnitionOffTime
14077065;9/12/2023 0:32;SG03;;IgnitionOffTime
14075242;9/12/2023 0:32;CDH60;;
14077070;9/12/2023 0:32;SG03;IgnitionOnTime;
14081004;9/12/2023 0:32;OP048;;
14075245;9/12/2023 0:32;CDH62;;IgnitionOffTime
14075246;9/12/2023 0:32;CDH62;IgnitionOnTime;
14075244;9/12/2023 0:32;CDH59;;IgnitionOffTime
14081005;9/12/2023 0:32;OP048;;
14081018;9/12/2023 0:34;OP048;;
14081019;9/12/2023 0:34;OP048;;
14081020;9/12/2023 0:34;OP048;;
14081580;9/12/2023 0:35;EX253;;IgnitionOffTime
14075487;9/12/2023 0:35;CDH61;;IgnitionOffTime
14075488;9/12/2023 0:35;CDH61;IgnitionOnTime;
14075247;9/12/2023 0:35;CDH73;;
14078405;9/12/2023 0:35;OP061;;
14075489;9/12/2023 0:35;CDH61;;
14075248;9/12/2023 0:36;CDH47;;IgnitionOffTime
14075254;9/12/2023 0:36;CDH47;IgnitionOnTime;
14075249;9/12/2023 0:36;CDH85;;IgnitionOffTime
14075250;9/12/2023 0:36;CDH85;IgnitionOnTime;
14075253;9/12/2023 0:36;CDH85;;IgnitionOffTime
14075264;9/12/2023 0:36;CDH85;IgnitionOnTime;
14075492;9/12/2023 0:36;CDH61;;
14076934;9/12/2023 0:37;MA087;;IgnitionOffTime
14079090;9/12/2023 0:37;MA087;IgnitionOnTime;
14075257;9/12/2023 0:37;CDH48;;IgnitionOffTime
14075258;9/12/2023 0:38;CDH48;IgnitionOnTime;
14082546;9/12/2023 0:38;EX404;;
14081021;9/12/2023 0:38;OP048;;
14075255;9/12/2023 0:38;CDH57;;IgnitionOffTime
14075260;9/12/2023 0:38;CDH57;IgnitionOnTime;
14081023;9/12/2023 0:38;OP048;;
14075256;9/12/2023 0:39;CDH62;;
14075493;9/12/2023 0:39;CDH61;;
14079266;9/12/2023 0:39;OP161;;
14098752;9/12/2023 0:39;CDH52;;
14077302;9/12/2023 0:39;EX369;;
14075259;9/12/2023 0:40;CDH62;;
14075494;9/12/2023 0:40;CDH61;;
14075362;9/12/2023 0:40;EX321;IgnitionOnTime;
14075363;9/12/2023 0:40;EX321;;IgnitionOffTime
14075364;9/12/2023 0:40;EX321;IgnitionOnTime;
14075261;9/12/2023 0:40;CDH65;;
14075267;9/12/2023 0:40;CDH48;;IgnitionOffTime
14075268;9/12/2023 0:40;CDH48;IgnitionOnTime;
14098753;9/12/2023 0:41;CDH52;;
14075262;9/12/2023 0:41;CDH57;;
14075263;9/12/2023 0:41;CDH85;IgnitionOnTime;
14118261;9/12/2023 0:41;EX596;;
14075366;9/12/2023 0:42;EX321;;
14075367;9/12/2023 0:42;EX321;;
14075281;9/12/2023 0:42;PAB06;;IgnitionOffTime
14075265;9/12/2023 0:42;CDH65;;
14075266;9/12/2023 0:42;CDH65;;
14075324;9/12/2023 0:42;PAB06;IgnitionOnTime;
14075269;9/12/2023 0:43;CDH65;;
14075270;9/12/2023 0:43;CDH62;;
14075272;9/12/2023 0:43;CDH65;;
14075271;9/12/2023 0:43;CDH48;;
14075274;9/12/2023 0:43;CDH65;;
14075273;9/12/2023 0:43;CDH48;;
14118262;9/12/2023 0:43;EX596;;
14075275;9/12/2023 0:43;CDH65;;
14118263;9/12/2023 0:43;EX596;;
14075276;9/12/2023 0:43;CDH57;;
14075280;9/12/2023 0:44;CDH60;;IgnitionOffTime
14075287;9/12/2023 0:44;CDH60;IgnitionOnTime;
14075277;9/12/2023 0:44;CDH57;;
14075278;9/12/2023 0:44;CDH48;;
14078763;9/12/2023 0:44;EX600;;
14075370;9/12/2023 0:44;EX321;;
14075279;9/12/2023 0:44;CDH57;;
14076760;9/12/2023 0:44;EX544;;
14075283;9/12/2023 0:44;CDH62;;IgnitionOffTime
14075286;9/12/2023 0:44;CDH62;IgnitionOnTime;
14078406;9/12/2023 0:45;OP061;;
14118266;9/12/2023 0:45;EX596;;
14075282;9/12/2023 0:45;CDH73;;
14076761;9/12/2023 0:46;EX544;;
14076762;9/12/2023 0:46;EX544;;
14118267;9/12/2023 0:46;EX596;;
14078764;9/12/2023 0:46;EX600;;
14078765;9/12/2023 0:47;EX600;;
14076763;9/12/2023 0:47;EX544;;
14075294;9/12/2023 0:48;CDH49;;IgnitionOffTime
14075295;9/12/2023 0:48;CDH49;IgnitionOnTime;
14075293;9/12/2023 0:48;CDH60;;IgnitionOffTime
14075297;9/12/2023 0:48;CDH60;IgnitionOnTime;
14075298;9/12/2023 0:49;CDH60;;
14075495;9/12/2023 0:50;CDH61;;
14075296;9/12/2023 0:50;CDH49;;IgnitionOffTime
14118270;9/12/2023 0:50;EX596;;
14118271;9/12/2023 0:50;EX596;;
14082558;9/12/2023 0:50;EX404;;
14075304;9/12/2023 0:51;PHK16;;IgnitionOffTime
14075305;9/12/2023 0:51;PHK16;IgnitionOnTime;
14075299;9/12/2023 0:52;CDH47;;
14075306;9/12/2023 0:52;CDH65;;
14075300;9/12/2023 0:52;CDH48;;
14075301;9/12/2023 0:53;CDH47;;
14075302;9/12/2023 0:53;CDH47;;
14075307;9/12/2023 0:53;CDH57;;IgnitionOffTime
14075303;9/12/2023 0:53;CDH47;;IgnitionOffTime
14075314;9/12/2023 0:53;CDH57;IgnitionOnTime;
14075308;9/12/2023 0:54;CDH65;;
14075309;9/12/2023 0:54;CDH65;;
14078784;9/12/2023 0:54;EX600;;
14075310;9/12/2023 0:54;CDH62;;IgnitionOffTime
14075312;9/12/2023 0:54;CDH62;IgnitionOnTime;
14081581;9/12/2023 0:54;EX253;IgnitionOnTime;
14081582;9/12/2023 0:54;EX253;;IgnitionOffTime
14075313;9/12/2023 0:55;CDH62;;
14078785;9/12/2023 0:55;EX600;;
14081583;9/12/2023 0:55;EX253;IgnitionOnTime;
14075311;9/12/2023 0:55;CDH62;IgnitionOnTime;
14081024;9/12/2023 0:56;OP048;;
14078786;9/12/2023 0:56;EX600;;
14078412;9/12/2023 0:56;OP061;;
14078413;9/12/2023 0:56;OP061;;IgnitionOffTime
14081025;9/12/2023 0:56;OP048;;
14075321;9/12/2023 0:57;CDH85;;IgnitionOffTime
14078787;9/12/2023 0:57;EX600;;
14078414;9/12/2023 0:57;OP061;IgnitionOnTime;
14076770;9/12/2023 0:57;EX544;;IgnitionOffTime
14076771;9/12/2023 0:57;EX544;IgnitionOnTime;
14075317;9/12/2023 0:57;CDH72;;IgnitionOffTime
14078788;9/12/2023 0:57;EX600;;
14075319;9/12/2023 0:57;CDH62;;
14075318;9/12/2023 0:57;CDH73;;
14078789;9/12/2023 0:58;EX600;;
14075320;9/12/2023 0:58;CDH49;IgnitionOnTime;
14076773;9/12/2023 0:58;EX544;;
14075322;9/12/2023 0:58;CDH85;IgnitionOnTime;
14078790;9/12/2023 0:58;EX600;;
14075323;9/12/2023 0:58;CDH65;;
14078791;9/12/2023 0:58;EX600;;
14076774;9/12/2023 0:58;EX544;;
14086840;9/12/2023 0:58;EX240;;
14078792;9/12/2023 0:59;EX600;;
14076775;9/12/2023 0:59;EX544;;
14098757;9/12/2023 0:59;CDH52;;
14078793;9/12/2023 0:59;EX600;;
14075325;9/12/2023 0:59;CDH48;;
14078794;9/12/2023 1:00;EX600;;
14075326;9/12/2023 1:00;CDH48;;
14075372;9/12/2023 1:00;EX321;;IgnitionOffTime
14081026;9/12/2023 1:00;OP048;;
14078795;9/12/2023 1:00;EX600;;
14075373;9/12/2023 1:00;EX321;IgnitionOnTime;
14081027;9/12/2023 1:00;OP048;;
14075327;9/12/2023 1:01;CDH65;;IgnitionOffTime
14075345;9/12/2023 1:01;CDH65;IgnitionOnTime;
14118272;9/12/2023 1:01;EX596;;
14081028;9/12/2023 1:02;OP048;;
14078796;9/12/2023 1:02;EX600;;
14076684;9/12/2023 1:02;CDH71;IgnitionOnTime;
14078797;9/12/2023 1:03;EX600;;
14076685;9/12/2023 1:03;CDH71;;IgnitionOffTime
14081585;9/12/2023 1:03;EX253;;
14076686;9/12/2023 1:03;CDH71;IgnitionOnTime;
14075338;9/12/2023 1:03;CDH48;;IgnitionOffTime
14075343;9/12/2023 1:03;CDH48;IgnitionOnTime;
14076687;9/12/2023 1:03;CDH71;;IgnitionOffTime
14081588;9/12/2023 1:03;EX253;;IgnitionOffTime
14076688;9/12/2023 1:03;CDH71;IgnitionOnTime;
14098762;9/12/2023 1:04;CDH52;;
14076689;9/12/2023 1:04;CDH71;;IgnitionOffTime
14075342;9/12/2023 1:04;PHK14;;IgnitionOffTime
14081029;9/12/2023 1:04;OP048;;
14075346;9/12/2023 1:04;PHK14;IgnitionOnTime;
14098763;9/12/2023 1:04;CDH52;;
14081030;9/12/2023 1:05;OP048;;
14076690;9/12/2023 1:05;CDH71;IgnitionOnTime;
14075344;9/12/2023 1:05;CDH65;IgnitionOnTime;
14075350;9/12/2023 1:06;PAB05;;IgnitionOffTime
14076691;9/12/2023 1:06;CDH71;;IgnitionOffTime
14075351;9/12/2023 1:06;PAB05;IgnitionOnTime;
14082870;9/12/2023 1:06;OP047;;
14076692;9/12/2023 1:06;CDH71;IgnitionOnTime;
14082871;9/12/2023 1:06;OP047;;
14075352;9/12/2023 1:06;CDH47;IgnitionOnTime;
14082872;9/12/2023 1:06;OP047;;
14076693;9/12/2023 1:06;CDH71;;IgnitionOffTime
14076694;9/12/2023 1:06;CDH71;IgnitionOnTime;
14076695;9/12/2023 1:07;CDH71;;IgnitionOffTime
14075368;9/12/2023 1:07;CDH48;;IgnitionOffTime
14075374;9/12/2023 1:07;CDH48;IgnitionOnTime;
14075356;9/12/2023 1:07;CDH85;;IgnitionOffTime
Message 3 of 3
79 Views
0
Syndicate_Admin
Administrator
Administrator

‎09-24-2023 03:12 AM

@Syndicate_Admin ,

¿Puede publicar sus datos de muestra como texto y no como una imagen (un archivo de Excel en algún lugar de la nube servirá)? Por favor, incluya también los resultados esperados.

Message 2 of 3
94 Views
0

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All