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: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Syndicate_Admin
Administrator
Administrator

I calculate time on auto

‎09-23-2023 08:13 AM

Hello everyone, I ask for your guidance. I'm working with power bi and DAX. I have a table that has vehicle on and off data and I need to calculate the time periods in which the vehicles are on. The table records the state every X time, so you can repeat both the status of IgnitionOnTime and IgnitionOffTime, the values clearly have their timeStamp. So, I need to be able to calculate the period of time that a vehicle is running. what I am trying to do is detect the change from the last IgnitionOnTime to IgnitionOffTime or from IgnitionOffTime to IgnitionOnTime, and thus be able to take the difference of time and obtain the ignition period. The table has registered several different vehicles and the blank spaces IgnitionOnTime and IgnitionOffTime are because the equipment is turned off.

2023_09_23_12_07_50_Libro2_Excel.png

Message 1 of 3
182 Views
0
2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

‎09-25-2023 04:46 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
113 Views
0
danextian
Super User
Super User

‎09-24-2023 03:11 AM

Hi @Syndicate_Admin ,

Can you please post your sample data as a text and not as an image  (an excel file somewhere in the cloud will do)? Please include expected results as well.










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
Message 2 of 3
133 Views
0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

August Carousel

Fabric Community Update - August 2024

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

View All