Forum Discussion
Subtract one time from another
Super UserYour 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?
Here is the file: https://www.dropbox.com/scl/fi/yhs3bcrb87bxq6ueo6byx/test.pbix?rlkey=gzhf02jc1wjwq78tti9b2s9fu&st=jc2ao4o7&dl=0
The id field will always be unique...
- lbendlin
I don't understand how Unit number correlate with "The name" items.
Note that your datetime slicers will not work as long as they come from the same table.