Forum Discussion

Student59's avatar
Student59
New Member
2 years ago

Time column

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?

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      Student59
      New Member
      2 years ago

      Thanks but A chart cannot be created with this value.

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