Building Income Statements in Power BI (with Chris Barber)

Profitability is a key metric for any business, as profits can be distributed back to shareholders either directly or indirectly. An income statement—also known as a Profit and Loss (P&L) statement—answers high-level questions such as “What was our net profit last year?” while summarizing key revenue (e.g., product revenue) and expense (e.g., R&D) items. Unlike static reports, a P&L semantic model provides granular detail, enabling users to explore insights such as “How was R&D spending distributed across projects, fiscal periods, or legal entities?” With a well-structured model, users can analyze financials dynamically through Power BI reports, PivotTables, and Excel formulas. GUEST BIO (Chris Barber)👤 Chris Barber is a Chartered Accountant (ACMA, CGMA), four-time Microsoft MVP, and author of Income Statement Semantic Models. He runs StarSchema.co.uk and has created popular YouTube videos (100K+ views) and courses (1K+ participants) focused on building Profit and Loss (P&L) reports in Power BI. RELATED CONTENT 🔗 PBIX Download - https://www.starschema.co.uk/downloads Website -- https://www.starschema.co.uk/ Linkedin -- https://www.linkedin.com/in/christophermichaelbarber/ VIDEO CHAPTERS 📺 0:00 - Video Start 5:00 - Start of Livestream LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽🌟 -- https://twitter.com/HavensBI -- https://www.linkedin.com/in/reidhavens -- https://www.youtube.com/c/HavensConsulting CHECK OUT OUR MERCH STORE 👕 -- https://havens-consulting.creator-spring.com/ HAVENS CONSULTING PAGES 📄 Home Page -- http://www.havensconsulting.net Blog -- http://www.havensconsulting.net/blog-and-media Blog Files -- http://www.havensconsulting.net/blog-files Files & Templates -- http://www.havensconsulting.net/files-and-templates Consulting Services -- http://www.havensconsulting.net/consulting-services Online Course -- https://www.havensconsulting.net/online-courses Contact & Support -- http://www.havensconsulting.net/contact-and-support EMAIL US AT 📧 [email protected] #PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #reporting #visualizations #finance #fpna #pnl #financialreporting #financialstatements