Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am trying to generate a table with by device the duration of each changeover done on that line.
I have as raw data a table with those column
Each entry give me aduration ofr a part of changeover on on the device. The changeovers are cut in several part and I need to agregate them in only one row to have the total duration of the changeover.
When the start time of the next entry is later than 60 minutes than the End time of the Entry, the next entry can be considered as another changeover.
I have here selected the entry that needs to be considered as one changeover. for weach I need to have one total duration.
Thanks in advance for your help
Solved! Go to Solution.
You have not received any replies... That means people don't understand your problem. Please therefore read this post -> https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/td-...
You have not received any replies... That means people don't understand your problem. Please therefore read this post -> https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/td-...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |