Time column

[Student59]

I need help.

I have a column for the hours of production.

I want to calculate the time difference between them and create a new column.

In this way, I will create a cycle time chart.

What formula should I use to create this column?

[Anonymous]

Hi, @Student59 

Based on your description, I have created some measures to achieve the effect you are looking for. Following picture shows the effect of the display.

DAX:

New Column:

DateDown =

VAR _dateDown =

    CALCULATE (

        MAX ( 'Date'[Date] ),

        FILTER ( 'Date', 'Date'[Date] < EARLIER ( 'Date'[Date] ) )

    )

RETURN

    _dateDown

Measure:

TimeDiff =

VAR _date1 =

    SELECTEDVALUE ( 'Date'[Date] )

VAR _date2 =

    SELECTEDVALUE ( 'Date'[DateDown] )

VAR _diff_second =

    DATEDIFF ( _date2, _date1, SECOND )

VAR Hours =

    INT ( _diff_second / 3600 )

VAR Minutes =

    INT ( MOD ( _diff_second, 3600 ) / 60 )

VAR Seconds =

    MOD ( _diff_second, 60 )

RETURN

    IF (

        NOT ISBLANK ( _date2 ),

        FORMAT ( Hours, "00" ) & ":"

            & FORMAT ( Minutes, "00" ) & ":"

            & FORMAT ( Seconds, "00" )

    )

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Student59]

Thanks but A chart cannot be created with this value.

I want to create a chart like below with this value.