Production identifier

[Carlend]

Hi, I have a problem that I can't solve. I should create a calculated column that identifies a certain routing to me. I have the timestamp of each cycle and the cycle number available. My idea is that of: if the N ° cycle is equal to 0 I write in all the lines the starting timestamp for that cycle and so on until I find zero again. I attach screenshots to try to explain better. It can be done?

Actual Scenario:

Timestam	N. Cicle
04/06/2021 08:59	0
04/06/2021 09:01	1
04/06/2021 09:03	2
04/06/2021 10:15	0
04/06/2021 10:17	1

Timestam	N. Cicle	Id. Production
04/06/2021 08:59	0	040620210859
04/06/2021 09:01	1	040620210859
04/06/2021 09:03	2	040620210859
04/06/2021 10:15	0	040620211015
04/06/2021 10:17	1	040620211015

[Jihwan_Kim]

Hi, @Carlend 

Please check the below picture and the sample pbix file's link down below.

It is for creating a new column.

ID Production CC =
CALCULATE (
LASTNONBLANK ( 'Table'[Timestam], MAX ( 'Table'[Timestam] ) ),
FILTER (
'Table',
'Table'[Timestam] <= EARLIER ( 'Table'[Timestam] )
&& 'Table'[N. Cicle] = 0
)
)

https://www.dropbox.com/s/dbo7x3xa2cha10w/carlend.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM