Forum Discussion
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 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?
14 Replies
- lbendlin
Super User
Subtract the two values and then use FORMAT to display the duration in a meaningful way.
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-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
