Delete data at the start and end of the day

[treza88]

Hi everyone,

Sorry for my English, but I will try to do my best to make myself understood, because I am French.

I have a data group that starts every day in the morning and ends in the evening. Each start and end of the day I also have a variable which is 0.

I would like to delete the start and end of day lines which have variable 0, and only these lines. Because in my data during the day there is this variable which is at 0 which I do not want to delete

I repeat it only at the beginning and end of the day until the variable is no longer at 0.

So I know that my explanations and information are incomplete, but I hope that you will help me, because my level with Power Query is very low.

Tell me what you need so you can help me

Thanks in advance.

[lbendlin]

you can post in french too if that is more convenient.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[treza88]

Thank you Ibendlin for your reply

I was unable to import my table, as it contains too many rows. Is there another way I can send you my data?

Here's a sample of my data

My fields are:
index, jour, mois, année, heure, minute, seconde, vitesse, etat_machine et date_heure_server.

index	jour	mois	année	heure	minute	seconde	vitesse	etat_machine	date_heure_server
37692	7	3	24	18	6	53	0.01	A	07/03/2024 18:07
37691	7	3	24	18	6	43	0.00	A	07/03/2024 18:07
37690	7	3	24	18	6	33	0.00	A	07/03/2024 18:07
37689	7	3	24	18	6	23	0.00	A	07/03/2024 18:07
37688	7	3	24	18	6	13	0.00	A	07/03/2024 18:06
37687	7	3	24	18	6	3	0.01	A	07/03/2024 18:06
37686	7	3	24	18	5	53	3.28	M	07/03/2024 18:06
37685	7	3	24	18	5	43	3.27	M	07/03/2024 18:06
37684	7	3	24	18	5	33	3.28	M	07/03/2024 18:06
37683	7	3	24	18	5	23	3.28	M	07/03/2024 18:06
37682	7	3	24	18	5	13	3.28	M	07/03/2024 18:05

And it's in relation to the speed field that I want to delete the lines if it's at 0.0... at the beginning and end of the day.
I want to use the "day" fields to determine the start and end of the day and speed if it's 0.0... to delete my lines.

The files sent are only samples, my data can be over several days in a row.