Semi-Additive Measures: Closing & Average Stock Balances
This lesson is part of the course
In this lesson
You find the last snapshot date of each month with MAXIFS, report the closing and average stock balance per month, and build a quarter closing balance that is not the sum of anything over time.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Columns vs Measures: Line Margin vs Total Margin % Locked
- Filter Context: One Measure for Every Slicer Combination Locked
- Removing & Keeping Filters: Share of Total, of Region & of Parent Group Locked
- Semi-Additive Measures: Closing & Average Stock Balances Locked
- Ranking with Ties, a Top 5 & the «Others» Line Locked
- New vs Returning Customers per Month Locked
- Dynamic Customer Segments from a Band Table Locked
- Capstone: Measure Branching & a KPI Page that Reconciles Locked