Calculate Table DAX

[Simon_Br]

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

[Simon_Br]

the solution is left outer join. So this question is answered.

[Simon_Br]

Thank 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

[Greg_Deckler]

@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