There is a way to do like a Math product() function like a kind of sum()

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!

0 2 72
2 REPLIES 2
Top Labels in this Space