Forum Discussion

82186's avatar
82186
Frequent Visitor
2 years ago

Subtract one time from another

The database has a counter for recording the time of signals (Date of recording) There is a machine and this machine sends a signal from the beginning of the cut (LD_11_Cnt_Saw1_Cut Start) and its co...
82186's avatar
82186
Frequent Visitor
2 years ago

I understand that they need to be subtracted, but I don't understand how to do it. Can you send me a sample code?

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

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-Forum/ba-p/963216

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/1447523

  • 82186's avatar
    82186
    Frequent Visitor
    2 years ago
    IDDate of recordingUnit numberThe name 
    128.06.2024 12.52.2313LD11_Cnt_Saw2_CutDone 
    228.06.2024 13.11.0113LD11_Cnt_Saw2_CutDone 
    328.06.2024 12.47.5446LD_11_Cnt_Saw2_CutStart 
    428.06.2024 13.06.1546LD_11_Cnt_Saw2_CutStart 

     

  • 82186's avatar
    82186
    Frequent Visitor
    2 years ago

    Is this information enough?

    (Date of recording) - Date of recording
    (Unit number) - unique number
    (The name) - Signal name

    There are two signals:
    (LD_11_Cnt_Saw2_Cut Start) - start cutting
    (LD11_Cnt_Saw2_Cut Done) - completion of the cut

    You need to subtract (LD11_Cnt_Saw2_Cut Done) from (LD_11_Cnt_Saw2_Cut Start)

    Thank you very much in advance!

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      Your sample data is inconsistent.  Please validate and correct.

       

       

      • 82186's avatar
        82186
        Frequent Visitor
        2 years ago

        Hello In the screenshot, you have displayed the table absolutely correctly. I have the same one. It is necessary to subtract the beginning of the cut (LD_11_Cnt_Saw2_Cut Start) from the end of the cut (ld11_cnt_saw2_cut) and thereby get the time for which the saw made the cut.

         

         

        If necessary, I can send the file itself. But it will have the same thing as in the screenshot