Could you support me to convert an excel formula to Power Query?

[easonzeng]

I need to convert this Excel formula into Power Query in dataflow.

=MINIFS(data[Date],data[Date],">="&data[@Date],data[Unbooked],1,data[Department],data[@Department],data[Store],data[@Store])

I have tried multiple ways to do it, including group by, but had no luck.

I would appreciate it if anyone could provide some insights.

Thank you.

Otic

[wdx223_Daniel]

NewStep=let a=Table.Group(data,{"Unbooked","Department","Store"},{"n",each List.Sort([Date])}) in Table.AddColumn(data,"newCol",each let b=a{[Unbooked=1,Department=[Department],Store=[Store]]}?[n]? in if b=null then b else List.Skip(b,(x)=>x<[Date]){0}?)