我在DAX（在Power Query中创建了新索引）中这样做了，并添加了新的列，将数据分隔为组并对TimeOfJob求和。

TimeOfWork = 

enter code here`var CurrentDate = 'Time registration'[CorrectedStartDate]
var Employee = 'Time registration'[WorkerPersonnelNumber]
var CurrentRow = 'Time registration'[Index]
var WorkParalel = 'Time registration'[TimeAllocationType]
var StartTime = 'Time registration'[CorrectedStartTime_T]

var NewFilteredTable = FILTER('Time registration',
'Time registration'[WorkerPersonnelNumber] = Employee &&
'Time registration'[CorrectedStartDate] = CurrentDate &&
'Time registration'[CorrectedStartTime_T] = StartTime &&
'Time registration'[TimeAllocationType] = "Bundle1")

return (CALCULATE(SUM('Time registration'[CorrectedTimeOfJob]), FILTER(NewFilteredTable,'Time registration'[Index]<=CurrentRow)))

我创建了新的计算列CadEndDate，我在其中使用：

CaEndDate = StartDate + TimeStart + TimeOfWork

然后我创建了第二列CaStartDate，在那里我写道：

CaStartDate = CalculatedEndDate - TimeOfWork

谢谢你帮我

你可以做的是在power query中基于一个组生成一个索引：

let
    Source = ....,
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Worker", Int64.Type}, {"Status", type text}, {"DateStart", type date}, {"TimeStart", type time}, {"DateEnd", type date}, {"TimeEnd", type time}, {"TimeOfJob", type time}, {"Paralel", type text}}),
    Partitions = Table.Group(
        #"Changed Type",
        {"Worker", "Status"}, {"Partition", each _}
    )[Partition],
    AddedOrderKeys = List.Transform(
        Partitions,
        each Table.AddIndexColumn(
            Table.Sort(_, {"Worker"}),
            "Order Key Within Partition",
            1
        )
    ),
    Result = Table.Combine(AddedOrderKeys),
    #"Changed Type1" = Table.TransformColumnTypes(Result,{{"Order Key Within Partition", Int64.Type}})
in
    #"Changed Type1"

一旦你的索引准备好了，你就可以创建你的计算列了：

CalculatedTimeStart = IF(AND('Table'[Paralel] = "Yes",'Table'[Order Key Within Partition] = 2), 'Table'[TimeEnd] - 'Table'[TimeOfJob],'Table'[TimeStart])
CalculatedTimeEnd = IF(AND('Table'[Paralel] = "Yes",'Table'[Order Key Within Partition] = 1), 'Table'[TimeStart] + 'Table'[TimeOfJob],'Table'[TimeEnd])