Forum Discussion
Helper ICalculate Table DAX
Hello,
I have a new question for the DAX Experts.....
In a table we have Start and End for a Dutysteps. I will create a calculation from End to Start from the new Step.
In each case, only the same step. A and B are two different ones. In the pattern only two are specified, in reality we have thousands.
Example:
| Step | PlannedStart | PlannedEnd | Calulate |
| A | 03.07.2023 08:00 | 03.07.2023 08:04 | 00:06:00 |
| A | 03.07.2023 08:10 | 03.07.2023 08:48 | 00:00:00 |
| A | 03.07.2023 08:48 | 03.07.2023 08:59 | 00:46:00 |
| A | 03.07.2023 09:45 | 03.07.2023 09:53 | 00:09:00 |
| A | 03.07.2023 10:02 | 03.07.2023 10:44 | 00:00:00 |
| A | 03.07.2023 10:44 | 03.07.2023 10:59 | 01:01:00 |
| A | 03.07.2023 12:00 | 03.07.2023 12:20 | 00:00:00 |
| A | 03.07.2023 12:20 | 03.07.2023 14:00 | |
| B | 28.07.2023 10:24 | 28.07.2023 10:28 | 03:32:00 |
| B | 28.07.2023 14:00 | 28.07.2023 15:00 | 03:46:00 |
| B | 28.07.2023 18:46 | 28.07.2023 18:49 |
We can i do that?
Simon
3 Replies
- Greg_Deckler
Community Champion
Simon_Br Not sure, but are you looking for something like these?
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
https://community.powerbi.com/t5/Quick-Measures-Gallery/Duration-to-Seconds-Converter/m-p/342279#M92 
Simon_BrThank you for the answer.
I don't know thies is the solution. I want je step calculate Start - End.
Example:
03.07.2023 08:10 - 03.07.2023 08:04 = 00:06
- Simon_Br
the solution is left outer join. So this question is answered.
