Capstone: Measure Branching & a KPI Page that Reconciles
This lesson is part of the course
In this lesson
You build a small KPI page for the current month: sales per region as a base measure, the prior month through a shifted date filter, the change vs prior month, a reconciliation check against the raw data and a column chart.
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