Forum Discussion

Carlend's avatar
Carlend
Frequent Visitor
5 years ago

Production identifier

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:

TimestamN. Cicle
04/06/2021 08:590
04/06/2021 09:011
04/06/2021 09:032
04/06/2021 10:150
04/06/2021 10:171

 

TimestamN. CicleId. Production
04/06/2021 08:590040620210859
04/06/2021 09:011040620210859
04/06/2021 09:032040620210859
04/06/2021 10:150040620211015
04/06/2021 10:171040620211015

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    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