Subtract one time from another

[82186]

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 completion (LD11_Cnt_Saw2_CutDone).

How can I make a request on DAX in which the final time will subtract the initial time and show the time of the cut itself?

[lbendlin]

Subtract the two values and then use FORMAT to display the duration in a meaningful way.

[82186]

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]

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-...

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/1447...

[82186]

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.

[82186]

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?

[82186]

Here is the file: https://www.dropbox.com/scl/fi/yhs3bcrb87bxq6ueo6byx/test.pbix?rlkey=gzhf02jc1wjwq78tti9b2s9fu&st=jc...

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.

[82186]

What can you do then?

[lbendlin]

Use disconnected tables for your slicers.

[82186]

Can you please send an example?

[lbendlin]

example of what?

Duplicate your table, or create separate tables for the time ranges. 

What is your business users' expectation?  Have they expressed how they would like to pick the date ranges?  Are they concerned about the amount of screen space taken up by your slicers?

[82186]

ID	Date of recording	Unit number	The name
1	28.06.2024 12.52.23	13	LD11_Cnt_Saw2_CutDone
2	28.06.2024 13.11.01	13	LD11_Cnt_Saw2_CutDone
3	28.06.2024 12.47.54	46	LD_11_Cnt_Saw2_CutStart
4	28.06.2024 13.06.15	46	LD_11_Cnt_Saw2_CutStart