Here a sum formula
SUM( SELECT( Deliveries[DeliveryCharge], AND( ([DateDone] >= [_THISROW].[BeginDate]), ([DateDone] < [_THISROW].[EndDate]) ) ) )
Same thing but with a Product() function like in Google appsheet
PRODUCT( SELECT( Deliveries[DeliveryCharge], AND( ([DateDone] >= [_THISROW].[BeginDate]), ([DateDone] < [_THISROW].[EndDate]) ) ) )
https://support.google.com/docs/answer/3093502?hl=en#null
I pretty not understanding why a simple function like doesn't exist!
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |