Forum Discussion
Subtract one time from another
Super UserPlease 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
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
Your sample data is inconsistent. Please validate and correct.
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
- lbendlin
The ID column in your sample was out of sequence. Should it be ignored and the sorting be done based on timestamp instead?