A balance fact table stores closing inventory each day. Management wants the month-end balance rather than the sum of daily balances. What kind of calculation is needed?

1. A semi-additive measure selecting the relevant closing date
2. COUNTROWS of the date table
3. A simple SUM over every date
4. An average of product identifiers