Power Apps + Power BI Estimation: Units, Area, Volume & Lump Sums (Refined UI)
After building the skeleton, Sam reveals a cleaner, faster estimation workflow: assign costs by unit, area, or volume, bundle lump sums into packages, and review everything in a presentation-ready dashboard—with full access to type & instance BIM parameters.
⏱️ Chapter markers
00:00 – Recap & goal: refine the estimation UI
00:26 – Per-unit pricing: set 844 units to $600 each
00:38 – Per-area pricing: $130/m²
01:00 – Update latency note (calc heavy table)
01:09 – Mixed methods by floor: lump sum, area, volume
01:29 – Per-volume pricing: $300/m³
01:38 – Lump sum package: $50,000 “Water Closet Accessories”
02:03 – Batch through categories to fill estimates
02:13 – Inspect type & instance parameters (fire rating, etc.)
02:34 – “Conditioning for Estimation” view (hides already-estimated items)
02:49 – 256 family types remaining → work the list to zero
03:14 – Lump-sum review: unique IDs + contents by category/family/type
03:54 – Drill into compositions with full parameter context
04:06 – Presentation page (read-only) for stakeholders
04:25 – Totals & breakdowns + length/area/volume context
04:53 – Fully customizable: tie to estimation codes/parameters
05:06 – More resources: Power Apps + Power BI tutorial
05:21 – Wrap & call for feedback
📚 Learning points
1️⃣ Multiple pricing modes — unit, area, volume, and lump sums in one flow.
2️⃣ Fast triage view — hide completed items and power through what’s left.
3️⃣ Parameter-aware QA — check type/instance fields while you price.
4️⃣ Audit-ready summaries — unique IDs for lump sums + a clean presentation page.
👍 Like • 🔔 Subscribe for more BIM + Power Platform workflows • 💬 Tell us how you’re using Power BI + Power Apps for estimation!