Module 05 · Data Model & measures

Budget usage % and variance

Two follow-up measures built on the earlier ones: budget usage percentage with DIVIDE, and the budget variance.

Step by step5 minLesson 22 of 37 Members

The last two measures are built from Total Expense and Total Budget, so you don’t have to write SUM again. % Pemakaian Budget answers "what percentage of the budget has been used", and Selisih Budget answers "how many rupiah are left". After this lesson, every number on the dashboard comes from these four measures.

Members only

Continue this course with a membership

Modules 1–2 of the Excel course are free. This lesson and 27 more are open to active members.

4 steps with a numbered picture
All 37 Excel lessons, plus the Power BI, Tableau & Data Viz courses
A new Excel & dashboard template every day, with resell rights
Take paid client projects on the Project Board

Become a member & unlock all Already a member? Sign in

One payment for 12 months, no automatic renewal. Back to the free lessons