Financial Statements with Power BI - Part 1 P&L/BS
summary
Shows a metadata-driven approach that turns a chart of accounts into formatted P&L and balance sheet layouts using a many-to-many bridge table (built in Power Query or T‑SQL) and a soft‑coded statement spreadsheet; delivers interactive drillthrough and versioning, exposes PBIX on GitHub for reverse engineering, and uses calculation groups and field parameters for row formats and dynamic columns. Claims enterprise reports render in ~40 ms rendering; some KPI/variant logic lives in DAX so pre‑calculation is recommended for performance.
AI-written summary · about
chapters (5)
- 0:00Start
- 8:52Converting running Sum into a M2M table
- 11:38The Final M2M Table - How to create it?
- 35:58Report Versioning
- 37:04Opening and Closing Balance for Balance Sheet
related talks
18mEmpowering Business Through Data
01h 08mAdvanced Modelling and Calculation Using the Power BI Designer
50mLet End Users Drive: Empowering User Control in Power BI Reports
50mBuilding an Empire - Implementing Power BI Step by Step
01h 04mCreate Reports That Help You Run Your Business
46mVisualizing Data for Non-Data Experts: Making Reports Accessible to All
58mReal world PowerBI
51mTroubleshooting Power BI Report Performance